Total or summing in the form with the subform

  • Thread starter Thread starter Revned
  • Start date Start date
R

Revned

Hello,

I have a subform in my Order Forms bound in a Query
how can I sum the amount in my subform in my txxtSubTotal in my form

thanks
 
Revned said:
I have a subform in my Order Forms bound in a Query
how can I sum the amount in my subform in my txxtSubTotal
in my form
Click to expand...

Set the Control Source of the text box on your main form to:
=[Sub1].[Form].[txtTotal]
substituting the name of your subform control for Sub1, and the name of the
text box in the subform's Form Footer section for txtTotal.

Note that you should not store the total in the main form's table.
 
Back
Top