I get #Error? or #Name? when I try to display data from my subform on my main form.

I get #Error? or #Name? when I try to display data from my subform on my main form.

To display a value from a subform on a main form, create a calculated control that refers to the subform control using the following syntax:

=Forms![formname]![subformname]![controlname]

For example, suppose you have an Orders form and an Orders Subform. In the form footer of the subform, you have a text box named OrderSubtotal that sums the records in the subform. To display the value of this control on the main form, use the following expression:

=Forms![Orders]![Orders Subform]![OrderSubtotal]

To learn more about calculating a total for a group of records on a form, click .

If you're already using this syntax and you still get an error, check to make sure that the form, subform, and control names are correct. Make sure that the names you're referring to are the names specified in the Name property for each object. Also make sure that you're including the exclamation point in the right places.

You can also use the Expression Builder to help you refer to other controls. For information on using the Expression Builder, click .