Referencing a combobox on a Navigation Form within another Navigation Form

[hueyhewy]

Hi All,



I am attempting to reference a combobox in a query that is on a Navigation Form within another Navigation Form.
So far I have been unsuccessful so I would appreciate any help.

The combobox is called "cboTier3"

The main form is "FrmMain"
The first navigation form is FrmDLMSearch (Navigation Tab 3)
The second navigation form is FrmDLMView (Navigation Tab 2)

I am able to reference a combobox on the first Navigation form using [Forms]![FrmMain]![NavigationSubform].[Form]![cboTier3] but I cant seem to reference the next form.

Screenshot below:



Thanks in advance

[ranman256]

reference ANY item by using the full path name

forms!myform!cboBox
or subforms
but use the builder to get the path correct!

[hueyhewy]

Thanks ranman26 I was unable to get the path using the expression builder. I restructured the navigation form in the end to get it working.