Reference Subform of Navigation form

[bconner]

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.

[Forms]![NavigationForm]![NavigationSubform].[Form]![Reporting].[Form]![cmbState]

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.

 

[arnelgp]

i think its only Navigatuonsubform you rederence:

Forms]![NavigationForm]![NavigationSubform].[Form]![cmbState]

 

[marlan]

First: Have a link to this at all times, I have it bookmarked.

Second: note that NavigationSubform and ReportingForm should be names of subform controls, witch may or may not be same as the name of the actual Form.
the [Form] keyword refers to the actual form.

 

[bconner]

arnelgp, thanks for the quick reply your solution worked!
marlan, thanks for the reference link this is helpful.