Calculated Controls in Forms

[J.Jackson]

Hi!
I need to create a sum from a column called "Total Cost"
in a subform (Workorder Parts) onto the main form
(Workorder). What calculated control do I use??

 

[Graham Mandeno]

Create a textbox in the header or footer of your subform:
Name: txtTotalCost
ControlSource: =Sum([Name of Cost field])
Visible: No

Now create another textbox on your main form:
ControlSource: =[Name of subform control].[Form]!txtTotalCost