Multiple Subform Calculation

  • Thread starter Thread starter rob c
  • Start date Start date
R

rob c

I am working on a form which includes two subforms, sub1 and sub2. Both
subforms have a "projectnumber" that has a one-to-one relationship with the
other subform, but the subforms need to remain separate on the form.

The form includes several calculations that consist of a field in sub1 that
needs to be multiplied by a field in sub2, i. e. sub1 * sub2. What do I need
to do in order to make sure that the subforms remain separate, but the
calculations are done one record at a time.

thank you,

rob
 
I would add a hidden textbox to the main form and set it = to the value in
the subform, like:

=[Forms]![MainFormName]![SubformName].Form![Field1]

Then do the same for the second subform. Now make a third textbox for the
calculation on the main form.
 
Back
Top