K kryten Registered User. Local time Today, 06:27 Joined Jul 24, 2004 Messages 40 Jul 31, 2004 #1 Hi all, I currently have a form which has within it an order details subform, what expression should I use on the main form to create a total price for the order when the price of each item is in the subform? Thanx
Hi all, I currently have a form which has within it an order details subform, what expression should I use on the main form to create a total price for the order when the price of each item is in the subform? Thanx
KenHigg Registered User Local time Today, 09:27 Joined Jun 9, 2004 Messages 13,327 Jul 31, 2004 #2 =sum(forms!mymainform!mysubform.form!mypricetextbox) ??? ken
R Rich Guest Jul 31, 2004 #3 add an unbound textbox to the subform footer, set its control source to =Sum([YourField]) on the main form add another unbound textbox, set its control source to =Forms!MainFormName!SubFormName.Form!SumControl
add an unbound textbox to the subform footer, set its control source to =Sum([YourField]) on the main form add another unbound textbox, set its control source to =Forms!MainFormName!SubFormName.Form!SumControl
K kryten Registered User. Local time Today, 06:27 Joined Jul 24, 2004 Messages 40 Jul 31, 2004 #4 Sum problem continues Hey guys thanks for your replies, I tried both and get this #Name? Help!
R Rich Guest Jul 31, 2004 #5 that's because you haven't referenced them properly. Use the Code Builder to get the syntax correct
KenHigg Registered User Local time Today, 09:27 Joined Jun 9, 2004 Messages 13,327 Aug 1, 2004 #6 Is this still a problem?
K kryten Registered User. Local time Today, 06:27 Joined Jul 24, 2004 Messages 40 Aug 1, 2004 #7 Thanks for your concern! I'm not sure what I did, I messed around with the syntax for a while and hey presto. Thanks anyway.
Thanks for your concern! I'm not sure what I did, I messed around with the syntax for a while and hey presto. Thanks anyway.