Search Form imbedded within Navigation Form - Query Question

[McArthurGDM]

Hi,



I have a navigation form set up with 5 different tabs. One of these tabs is a Search Records page. There is a subform built into the navigation page that is my Main Search page, as should be with a Navigation Form. Within this Search Page is a Multiple Items form that is built on a query.

SO

Main Navigation Tab -> SearchMain -> SearchForm

Here is a picture:



Now, if I were to input, say, Like "*" & Forms!SearchMain!IssuingAgencies & "*" within the query that the Search Form is built off of, then nothing is prompted to my screen for input. However, if I run the Main Navigation form and open up this Search Records tab, I am prompted for input.

How do I get it so that I am not prompted for input anymore?

Thanks,

[June7]

See if this helps https://www.accessforums.net/forms/t...orm-32053.html

[McArthurGDM]

I think my issue might have 1 more layer of complexity, since my query results are a subform of my search form. My search form is a subform of my main navigation form. As you can see, this is complex.

Ideally, I should be able to do something like

Forms!NavigationForm!NavigationSubForm.SearchMain! IssuingAgenciesTXT

But, alas, it dosen't work and I am still prompted for input.

My issue is exactly the same as the guy whose post you linked. However, it has an added layer of complexity because of the subform, built into the subform haha.

[McArthurGDM]

SOLVED

I figured this out in 2 ways:

1) The Multiple Items list does not refresh with the given VBA commands. You can refer to the solution of fixing this here:

http://kbase.icbconsulting.com/vba/r...on-access-menu

2) In order to get the parameters to stop popping up you have to specify the right control source within the criteria - that is

[Forms]![MainNavigationForm]![NavigationSubform].[Form]![ControlSourceTXT]

I hope this is helpful.