Hi all,
I am trying to reference a control on a subform of a Navigation form
Below is the Hierarchy
NavigationForm
NavigationSubform
ReportingForm
cmbState (This is the control)
Below is the code I entered into the Query where clause for State.
When I execute the query it still prompts me for a state instead of reading it from the cmbState control on the ReportingForm.
Any help is appreciated.
I am trying to reference a control on a subform of a Navigation form
Below is the Hierarchy
NavigationForm
NavigationSubform
ReportingForm
cmbState (This is the control)
Below is the code I entered into the Query where clause for State.
Code:
[Forms]![NavigationForm]![NavigationSubform].[Form]![Reporting].[Form]![cmbState]
Any help is appreciated.