Problems with finding texboxes, is there a way to show what a [Form]!... ect returns?

[offie]

I am using navigations form so the names are tricky to start with, for some reason when I refer to textbox in one form, this is in the same place as another texbox (that I can find and works as criteria) it just doesn't work.

So my question is, are there ways of testing to see what the output of a [Form]!.., etc. is?



Or better yet, a way that access gives you the name of the place where it is?

Thanks!

[Dal Jeanis]

First, if you're using navigation forms, I believe you have to remember that only the open form is loaded, so there's nothing to refer to on any other form.

Second, as long as the form is open, you can open the immediate window (alt-pf11) and type in

debug.print [forms]![whateverlongthingyou].Form![thinkwillwork].Name

and if you got it right, then it will type out the name of the control.

You can also use debug.print to walk from the control upward.

In control List0's afterupdate, you can have

debug.print Me.List0.name
debug.print Me.name

which will print List0, then the name of the form List0 is on. If it's on a subform, then

debug.print Me.Parent.name

will get the name of the parent form.

This site is a wonderful reference for how to refer to controls and forms on other forms/subforms.
http://access.mvps.org/access/forms/frm0031.htm

[offie]

Exactly what I was looking for, thanks!

[Dal Jeanis]

You're welcome. Please mark the thread "solved". Top of page, under "thread tools".