expression problem

kryten

Registered User.
Local time
Today, 06:27
Joined
Jul 24, 2004
Messages
40
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
 
=sum(forms!mymainform!mysubform.form!mypricetextbox)

???
ken
 
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
 
Sum problem continues

Hey guys thanks for your replies,

I tried both and get this #Name?

Help!
 
that's because you haven't referenced them properly. Use the Code Builder to get the syntax correct
 
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.
 

Users who are viewing this thread

Back
Top Bottom