Calculated Controls in Forms

  • Thread starter Thread starter J.Jackson
  • Start date Start date
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??
 
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
 
Back
Top