Adding two separate sub-form totals on main form

[christ153]

Hi all,
I have a main form that has two subforms in it. Each subform has a total of a price column in it. I want to be able to show the sum of both of these totals on the bottom of the main form. How would I go about doing this?

[rpeare]

the easiest way is probably to have a field on your main form with a controls source of

=[Forms]![MainForm]![Subform1]![TotalField] + [Forms]![MainForm]![Subform2]![totalfield]

where you'd substitute in your main form and subform names and the NAMES of the fields that contain the totals within those subforms.

[christ153]

I have a query that calculates this, I was just wondering how to show this in the text box on the form, and how to make it update automatically when you add more items in the subform.

[christ153]

Awesome, I got it, thanks!