Results 1 to 6 of 6
  1. #1
    Camp is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    5

    Forms Real Name


    I am working with a form that I renamed after I created a form / sub form relationship

    Now when I try and write VBA code to manipulate the main form it can’t find the main form because I changed the name and don’t recall what the original name was

    I am unable to select the main forms outer perimeter, like I can with the sub form, to see what main forms actual name is.

    How can I find the name of the main form, the name VBA is looking for when I write code related to the main form?

    Thank you

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I'm confused, as you should be able to (have to) use the form's current name. If the form is in design view, its name should show in the top of the window, or tab if in tabbed view.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    look at the properties sheet, you'll find the name under the other tab.

    And if your code is in a subform, you can refer to the main for by using parent - i.e. parent.name

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Quote Originally Posted by Ajax View Post
    look at the properties sheet, you'll find the name under the other tab.
    Not on my installation of 2010 32bit. Nor 2007.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by pbaldy View Post
    ...I'm confused, as you should be able to (have to) use the form's current name...
    I'm confused, too...for the same reason! If you change the name of a Form, Access modifies the name everywhere to match the new name, even in the systems table MSysObjects.

    If your manipulation in code is failing it most probably is because of something else. It would probably help us to help you if we could see the ciode that is failing.

    Linq ;0)>

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    Not on my installation of 2010 32bit. Nor 2007


    Well I'm confused as well. Perhaps the OP is using tabbed forms and has removed the tabs. Or perhaps is trying to find all the places in vba code where he referred to the form - in which case perhaps the form is/was called frmInput per an earlier thread

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

Similar Threads

  1. real estate matching
    By ilbo in forum Queries
    Replies: 8
    Last Post: 07-14-2014, 10:23 PM
  2. Real Problem with Year_Table
    By cuddles in forum Access
    Replies: 1
    Last Post: 06-13-2014, 10:52 AM
  3. Translating Windows name into Real Name
    By runthis457 in forum Forms
    Replies: 13
    Last Post: 02-14-2011, 06:20 PM
  4. real time clock
    By krai in forum Access
    Replies: 1
    Last Post: 05-13-2010, 05:11 AM
  5. newbie-real NOVICE
    By SHCC in forum Database Design
    Replies: 1
    Last Post: 02-09-2010, 03:42 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