Is there an easy way to obtain a value from a field in a subform that is highlighted (have focus) on the main form? Right now I am receiving a #Name error message. This is the coding I am using in a text box on the main form:



Where Forms!frmsubsubmittals2 is the sub form.

Any help is greatly appreciated.

Kevin

Try:

=Forms.YourMainFormName.YourSubFormCONTROLName.Form.YourControlNameHoldingTheVal
ue

Also see this. It's very helpful when referring to forms/subforms/subsubforms.

thank for your help

No problem.