Adding field from Sub form to main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
NNlogistics said:
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.
Click to expand...


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
 
Back
Top