Adding field from Sub form to main form

[Guest]

I have an order form with an Order Number and some Customer Information and
use a subform enableing input of each line item. The line item has item
number, price and weight.
I would like to keep a running total of the price and weight on the main
order form. I cant seem to conceptualize the process. I was thinking of
just adding the field from the sub to the main but on what event, make it
happen just once. I must be having brain freeze.

 

[Marshall Barton]

I have an order form with an Order Number and some Customer Information and
use a subform enableing input of each line item. The line item has item
number, price and weight.
I would like to keep a running total of the price and weight on the main
order form. I cant seem to conceptualize the process. I was thinking of
just adding the field from the sub to the main but on what event, make it
happen just once. I must be having brain freeze.

The subform must calculate its own totals in its header or
footer sections. The text box expression would be like:

=Sum(Price)

Then the main form can use a text box to display the total
from the subform by using this kind of ecpression:

=subformcontrol.Form.totaltextbox