sum of fields outside of a subform

[Steven Cheng]

I have three forms, (A, B, and C). B is a subform of A,
and C is subform of B. I want to calculate a field on
subform C and have the amount showing on the detail
section on subform B. I also want to add a control that
sum up a a field in B and have it show on form A.

I am stuck.

 

[Jim/Chris]

It looks like your problem is in how to reference a subform
control. Here is something I got from Van T. Dinh on a
previous post. I think it will help

[Forms]![frmMain]![frmSub1].[Form]![frmSub2].[Form]![FieldOnfrmSub2]

provided that [frmSub1] and [frmSub2] are the names of the
*SubformControls* which can be different from the names of
the Forms you used as the Subforms (or more accurately, the
SourceObjects of the SubformControls).

You can only check the name of the SubformControl in the
DesignView of the Parent Form.

Jim