Calculated Controls in Forms

J

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??
 
G

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
 
Top