By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

Assigning Values to TextBox on Form

P: 1
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
Oct 11 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
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
Oct 14 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
[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
Oct 14 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.