How to track where a parameter is being called for?

[markmarko]

I'm having a recurring problem. As I'm working on a form is based on a query,
with subforms also based on queries, every once in a while it will start
asking me for some obscure parameter.

Generally it's been from removed or renamed fields, but that aren't
applicable anymore to the form. Recently I had the problem, and I check and
rechecked all the SQL for the queries feeding the form and subforms. Finally,
I realized that it was in the Master Field property of a subform control.

My question then, is this... When opening a form asks for a parameter, is
there a clear way to determine where that parameter is being called from?
(ie, a particular query, a property, etc?)

This keeps happening to me, and it's driving me batty!

 

[John W. Vinson]

My question then, is this... When opening a form asks for a parameter, is
there a clear way to determine where that parameter is being called from?
(ie, a particular query, a property, etc?)

Not very easily. I'll check in recordsources first of course; rowsources of
combos (though they're rarely parameter queries); Reports' Sorting and
Grouping (a favorite place for such things to be overlooked, for me anyway).

There are some third-party tools to find references anywhere in the database:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

Note that if you have Name Autocorrect turned on, deleted references can hang
on in the black shadows, and keep popping up even when you KNOW that they've
been deleted. Just one of the many reasons this feature is widely known as
Name Autocorrupt.

John W. Vinson [MVP]

 

[markmarko]

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com
Thanks!

Note that if you have Name Autocorrect turned on, deleted references can hang
on in the black shadows, and keep popping up even when you KNOW that they've
been deleted. Just one of the many reasons this feature is widely known as
Name Autocorrupt.

Oh, goody... Autocorrupt! Just what I needed!