Referencing a Subform Control on a Navigation Tab page

[McArthurGDM]

So, I have a Main Navigation page.



I have a subform with controls in it.

I want to reference those controls in query.

I try this

forms![MainNavigation]![NavigationSubform].

But it wont let me choose my actual subform.

How do I do this?

[ranman256]

you missed a 'form'. Use the BUILDER to get the full paths.

forms![MainNavigation]!NavigationSubform]!forms.control

[McArthurGDM]

The name of my navigation form is MainNavigation

The subform is named SearchMain


the control on SearchMain is IssuingAgency


I can't seem to get it to work.

[McArthurGDM]

[forms]![MainNavigation]![NavigationSubform].[Form]![IssuingAgency]

This works.