Total box at bottom of form

[jimmyg via AccessMonster.com]

I have a purchase order form that has a sub form showing rows of items to
order and quantities that add up a sum total at the end of each row. My
question is how do I add a total order box that will add up each sum total at
the bottom of my form.

 

[Arvin Meyer [MVP]]

Put a footer on the subform and set its controlsource to:

= Sum([sum total])

Now name it something like txtSubformTotal

you can set its height to 0" and hide it next to the footer separator. Then
put a textbox on the mainform and set its controlsource to:

= Forms!MainFormName!SubformControlName.Form!txtSubformTotal

That will set the textbox equal to the textbox in the subform's footer.

 

[jimmyg via AccessMonster.com]

Put a footer on the subform and set its controlsource to:

= Sum([sum total])

Now name it something like txtSubformTotal

you can set its height to 0" and hide it next to the footer separator. Then
put a textbox on the mainform and set its controlsource to:

= Forms!MainFormName!SubformControlName.Form!txtSubformTotal

That will set the textbox equal to the textbox in the subform's footer.

I have a purchase order form that has a sub form showing rows of items to
order and quantities that add up a sum total at the end of each row. My
question is how do I add a total order box that will add up each sum total
at
the bottom of my form.

Thanks very much, I had been trying everything to get to total to work.

Jimmyg