WHERE USED

[David]

Hi,

Is there a way within Access to determine where a field is used/updated? In
other words, how can I query the queries or code, to determine where FIELDA
is referenced?

 

[Jerry Whittle]

Open up Help and search on Object Dependencies.

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's a good way to
find orphans. However I don't know if it will go down to the level that you
are looking for.

http://www.rickworld.com/