Assigning Values to TextBox on Form

[thomasryder]

I have a Form with a subform which also has a subform. The Primary Form represents a medical invoice. The First subform represents the various services associated with the invoice. The subform on the subform(individual services) lists the payments for each individual service and who paid.

On the Primary Form I want to show the Total Cost of Services from the services subform and the Total Payments (from the payments subform) and then calculate the balance due, if any.

The following code worked for putting the total cost of services on the Primary Form - "[FMedicalService].[Form].[SumTotalCost]". I have tried similar code for the payments ("[FPayments].[Form].[TotalPmts]") but it doesn't work.
Can anyone explain why this wouldn't work?

Thanks

Tom

[PEB]

Hi

Try with

"[FMedicalService].[Form]![SumTotalCost]". AND ("[FPayments].[Form]![TotalPmts]")

Best regards

I have a Form with a subform which also has a subform. The Primary Form represents a medical invoice. The First subform represents the various services associated with the invoice. The subform on the subform(individual services) lists the payments for each individual service and who paid.

On the Primary Form I want to show the Total Cost of Services from the services subform and the Total Payments (from the payments subform) and then calculate the balance due, if any.

The following code worked for putting the total cost of services on the Primary Form - "[FMedicalService].[Form].[SumTotalCost]". I have tried similar code for the payments ("[FPayments].[Form].[TotalPmts]") but it doesn't work.
Can anyone explain why this wouldn't work?

Thanks

Tom

[MMcCarthy]

[size=2]Try this:[/size]
[size=2][/size]
[FMedicalService].Form![FPayments].[TotalPmts]

This will refer to the control [TotalPmts] on the second subform is run from the main form.

I have a Form with a subform which also has a subform. The Primary Form represents a medical invoice. The First subform represents the various services associated with the invoice. The subform on the subform(individual services) lists the payments for each individual service and who paid.

On the Primary Form I want to show the Total Cost of Services from the services subform and the Total Payments (from the payments subform) and then calculate the balance due, if any.

The following code worked for putting the total cost of services on the Primary Form - "[FMedicalService].[Form].[SumTotalCost]". I have tried similar code for the payments ("[FPayments].[Form].[TotalPmts]") but it doesn't work.
Can anyone explain why this wouldn't work?

Thanks

Tom