Subform calculation problem

[david444]

I have a form with a subform on it. I want the total of the parts used to be calculated from the subform and then displayed on the main form.
The database is attached.

 

[scottfarcus]

total price? total quantity?

 

[roelandkim]

See the attached file for what you want. Basically in the footer of the subform total the fields you want, in this case cost. Than on the main form refer to the control in the footer. Once you look at the example it should make some sense...

 

[scottfarcus]

The control source of the unbound text box you want to fill should be:

=[tblPartsUsed Subform].Form!Total