Enter Parameter value on startup (1 Viewer)

[boerbende]

Dear fellow developers

When I develop, I sometimes create a new version of a form.
For example I make a copy from
frm_formV1
to
frm_formV2

But in this case the frm_formV2 opens with a message box
ENTER PARAMETER VALUE
forms!frm_formV1!test_date

I understand the message, I need to update the reference to the new name.
I scanned the code in the project but can't find this string (not even a part of it). So it is a reference in a field or a query. I will find it, that is not the issue. But I am wondering:
does Access have a tool to help the developer with indication where this message originates?

So the find function in the VBA code I understand, but how to search the rest of Access (queries, recordsets etc)

Many thanks

Ben

 

[MarkK]

I rarely use this notation in a query...

Forms!SomeForm!SomeField

...because of this fragility.
And doubly so, I would never use this notation...

Forms!Form1!SomeField

...on Form1. Form1 IS Form1, so there's no need for an object on Form1 to seek a reference to its own parent using the Forms collection. I would establish this reference for controls on the form in question using a shorter reference path.

 

[Galaxiom]

Install V-tools and use Total Deep Search.

BTW Be aware that changing object names will also change some of the other references to it if Access has Name AutoCorrect turned on.

 

[boerbende]

Thanks Both.
The reference I found back in the recordsource of the form. I think this was done with the builder.
Busy testing Vtools!! this looks exactly what I need