Hi. I am having trouble referencing controls on navigation subform. I built a form to run my query (SearchForm) and got it where I wanted then I created a navigation form and I typed in the name of the query (SearchForm) on the tab everything loaded and now it keeps asking me for parameters for all of my controls on the query (SearchForm). I figured out I have to change the name of the criteria in the query design view now that it is on the navigation subform but it still ask for the parameters.
This is what I have in the query design view:
Field: Fname
Table:Sea
Group By
Criteria: Like "*" & [Forms]![NavigationForm].[Form]![NavigationSubform].[Forms].[FNametxt] & "*"
I thought this was the right format for it. The one thing that is strange is I am use to Access suggesting what to type after Form and when typing in this Criteria it did not do that after the [NavigationSubForm] part.