Results 1 to 3 of 3
  1. #1
    joekuhn is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    18

    Access Reference

    I have a database in Access 2007 with a main form and several subforms which function ok. However one of the subforms cannot be accessed by code. In the object browser this subform is not listed but I can find it when I click on the main form. When I click on the subform and then click on it's address I get the message: "Cannot jump to this "address" because it is in the library "address" which is not currently referenced." What is the problem and how can this be corrected?

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Subforms are not referenced by their subform name. They are referenced by the subform CONTROL which HOUSES the subform on the parent form. But if the two share the same, exact name, then you can use the subform name. However, if they are different then you must use the subform CONTROL'S name and not the subform name.

    See the screenshot here on my tutorial that shows you what I'm talking about.

  3. #3
    joekuhn is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    18

    access reference

    Thank you for your reply. It helped me to better understand how to refer to a subform, but that was not my problem. My problem was the wrong property set for my subform. I corrected this and my problem is solved.

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

Similar Threads

  1. Access SQL syntax Reference other tables
    By Lorlai in forum Queries
    Replies: 3
    Last Post: 06-08-2011, 05:21 PM
  2. need help with reference..
    By dada in forum Programming
    Replies: 3
    Last Post: 09-17-2010, 06:07 PM
  3. Reference Problem
    By ksmithson in forum Forms
    Replies: 9
    Last Post: 07-15-2010, 01:22 PM
  4. Ms Access Reference Books
    By dbman in forum Access
    Replies: 2
    Last Post: 01-27-2008, 06:06 PM
  5. Access 2007 Attachments - Relative reference
    By soringc in forum Programming
    Replies: 0
    Last Post: 11-22-2007, 10:47 AM

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