var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Referencing a combobox on a Navigation Form within another Navigation Form
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.
Thanks in advance
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007
Thanks apr pillai, I couldn't seem to get this to work so I ended up restructuring the forms.