Total or summing in the form with the subform

[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

 

[Allen Browne]

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

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.