Object Dependency for Expressions in Query?

[accessnewbie352]

Hello - i am trying to modify someone else's database and it is very convoluted. I am trying to rename some of the expressions in a query but am afraid to do so in case they are linked to either another expression in the query or used in a different query. Is there a way I can use something like the object dependency option to see anywhere the expression is currently being used?

[June7]

No, Access does not have that capability built-in. Requires 3rd-party add-in. I use Rick Fisher's Find & Replace for Access, cost about $50. A freebie called V-Tools has good reviews.

[accessnewbie352]

Thank you for that suggestion - I will check V-Tools out.