Results 1 to 2 of 2
  1. #1
    rts is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    34

    Subform Reference on Navigation Form

    Hello,

    I created a combo box on my RFI form that Applies a Filter on my RFI Forms depending on which selection the user makes. I'm having trouble getting this to work in my Navigation Subform. My Navigation Form is called "PROJECT_MAIN," my subform is called "RFI" and the Control that houses the subforms is "PM_SUBFORMS." The control on it to get to the RFI Form is "RFI_NAV" but I think that just refers to the tab control, not the actual container that is housing my subform. The control on the RFI is called "FILTERRFI"

    I tried using [Forms]![PROJECT_MAIN]![PM_SUBFORM]!Form.FILTERRFI to reference the control, but it didn't work. I did other variations I found on the web as well and can't seem to get the syntax right to reference the control on my subform.



    I'd really appreciate some help, I've been having trouble with subform reference for a while.

    Thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,627
    Is that a typo in the post? Is it PM_SUBFORMS or PM_SUBFORM?

    I haven't used Navigation form. Want to provide file for analysis? Follow instructions at bottom of my post.
    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.

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

Similar Threads

  1. Replies: 6
    Last Post: 12-19-2013, 12:34 AM
  2. How to reference a form in the Navigation Form
    By HarryScofs in forum Access
    Replies: 3
    Last Post: 08-18-2011, 04:46 PM
  3. form/subform reference problem
    By dbertanjoli in forum Forms
    Replies: 1
    Last Post: 01-10-2011, 03:31 PM
  4. Creating a reference to the subform.
    By evander in forum Forms
    Replies: 2
    Last Post: 05-26-2010, 09:39 AM
  5. Can't reference control in subform
    By evanscamman in forum Forms
    Replies: 0
    Last Post: 12-25-2007, 06:47 PM

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