Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2016
    Posts
    2

    Unanswered: Referencing a combobox on a Navigation Form within another Navigation Form

    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:

    http://i65.tinypic.com/rm6ujn.jpg

    Thanks in advance

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    180
    [Forms]![FrmMain]![NavigationSubform].[Form]![NavigationSubForm2].Form![cboTier3]
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    Jul 2016
    Posts
    2
    Thanks apr pillai, I couldn't seem to get this to work so I ended up restructuring the forms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •