syntax for referencing controls on a navigation form:
[Forms]![Navigation Form]![NavigationSubform].[Form]![controlName]
Likely, the name of your navigation form is "Navigation Form" if you kept the default name, so the suggestion is literal where that is concerned.
"NavigationSubform" refers to the subform control that holds the forms. Again, that may or may not be the name of yours.
Control name is the name of the control you want to reference. At least I think that's what you're asking for.
Why would you want to complicate this by having a query refer to a control embedded in a nav form as well as if you open the form directly??
Last edited by Micron; 06-19-2019 at 07:30 PM.
Reason: spelin and gramur
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.