Calculated Field from records in sub-form

[smanuel]

I need to place a text box on the form and the data needs to be the sum of a field in each record of the sub-form. How do I do this?

Ex. "Amount" is the field in sub-form and "Total" is the text box on the form which needs to add the Amount for each record together.

 

[CosmoKramer]

Set up your calculated field in the form footer of your subform. Then make that field the control source of the text box in your main form.....