Forms Real Name

[Camp]

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

[pbaldy]

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.

[CJ_London]

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

[pbaldy]

look at the properties sheet, you'll find the name under the other tab.

Not on my installation of 2010 32bit. Nor 2007.

[Missinglinq]

...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)>

[CJ_London]

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