Results 1 to 4 of 4
  1. #1
    altemir is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    31

    Referencing Combo Box in a Tab Control within a Navigation Subform

    How would I reference a combo box within a Tab Control that in turn is within a Navigation Subform? I'm looking for something like:



    Forms!frmMain!NavigationSubform!TabControlName!Com boBoxName

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    you shouldn't need the tab control name, just the name of the form, subform and the combo box within the subform.

    The syntax is:

    Forms!formname!subformname.Form.controlname

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I don't like the Navigation form. Think its only justification is for web database.

    Review https://www.accessforums.net/forms/t...orm-32053.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    altemir is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    31
    Thanks, rpeare. I thought the tab control acted as a sort of container, but I guess it doesn't as you point out. This is what ended up working for me:

    Forms!frmMain!NavigationSubform.Form!ctrInspection Lines.Form!cboPartNumber

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-15-2013, 03:36 PM
  2. Replies: 8
    Last Post: 02-04-2013, 11:32 AM
  3. VBA Referencing Subform Control Error 2465
    By Jester0001 in forum Programming
    Replies: 3
    Last Post: 05-30-2012, 07:31 AM
  4. referencing a control
    By looloo in forum Programming
    Replies: 3
    Last Post: 09-23-2011, 07:57 PM
  5. Combo box to control subform records
    By Robmls in forum Forms
    Replies: 8
    Last Post: 05-13-2011, 06:31 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums