Values in subform are added and displayed on main form

[GT_engineer]

I have form with a subform. The subform displays info in datasheet mode and will have fields, Items and Cost.

I want a text box on the main form that displays the summation of all the items' cost. Any ideas? Thanks

 

[boblarson]

Here's a sample on how to do it from my website.

http://downloads.btabdevelopment.com/Samples/subforms/SAMPLE-SubformTotalOnMainForm.zip

 

[GT_engineer]

Hi Boblarson

Worked like a charm