Search code examples
vbaformsms-accesssyntax-errorms-access-forms

Passing Query Expression through Naviagtion Form


I have been practicing the use of building expressions through query design. I have created a custom search query using textfield's and a listbox from a form. Now if I run the query through the form it works. But when I run the query through the form after its been placed within navigation form it does not work. I receive the pop up window to input parameter values manually. I am trying to adjust the expression but cant seem to get the syntax correct.

enter image description here

Below is amended expression but still does not work

[Forms]![Navigation Form Main]![Reports Form]![customerListBox]

For clarification the report form is a tab within my navigation form and yes the expression is being called only when the reports form tab is selected.


Solution

  • Instead of [Reports Form], try [NavigationSubform] which is default name of container holding [Reports Form].