sum in subform displayed in masterform

[Brad]

i'm trying to sum a field in a subform and display it in
the master form - currently i'm trying to sum the field
in the footer of the subform and then using that field as
the value of a field in the master form and i keep
getting "Name?". any suggestions?

 

[Kevin Sprinkel]

This approach should work; syntax to display field from
subform. I had similar problems caused by using the name
of the subform rather than the name of the subform control
in the main form that 'houses' the subform.

Also check that your reference is to the subform's control
name rather than its underlying source, which if both are
the same, can cause this error.

=(<nameofsubformcontrol>.Form!<subformcontrolname)

HTH
Kevin Sprinkel