Finding double name in MS access 2010

[Lou_Reed]

When I create a name in MS access 2010 sometimes, I get an error that this name is already in use. That is helpful.

But how do I find the original use? Is there an easy way? I sometimes find the original, but it is mostly by accident.



Any help appreciated.

Thanks in advance.

Respectfully,

Lou reed

[ranman256]

What do you mean, 'already in use'?
entering data in a form?
opening the db?

[Lou_Reed]

When I am in the properties window after I create a new control, MS Access 2010 gives it a name that is quite vague, like label33165. I like to change the names to something more descriptive.

However, sometimes I get an error that the name is already in use and I must change it to something else. This often makes me curious as to where the original name was used? I am sometimes surprised
that the name is already in use and sometimes I can find the original use. But I do not always find it.

I am just wondering if there is systematic methodology to go about find it. I am just curious and I do not want double names.

Any help appreciated.

Thanks in advance.

Respectfully,

Lou Reed

Any help appreciated. Thanks in advance.

[pbaldy]

Remember the drop down at the top of the properties window I mentioned in another thread? That would allow you to find the existing control.

[Lou_Reed]

Okay, I thought that was the way to do it.

Respectfully,

Lou Reed