Adding field from Sub form to main form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NNlogistics - 26 Sep 2007 14:26 GMT

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.

Signature

Thanks for any assistance

Reply to this Message

Marshall Barton - 26 Sep 2007 15:25 GMT

>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
[quoted text clipped - 3 lines]
>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

Signature

Marsh
MVP [MS Access]

Reply to this Message