Find all uses of a query in an access application

Question

I made a standalone Access 2003 app with a bunch of forms that is beginning to get unruly. I'm trying to clean it up a bit and I'd like to do things such as find all uses of a query so that I can make some global updates. I can use ctrl-f to find uses of a query in code but my question is: Is there an easy way to search the entire app to find where queries are used in the control's properties window such as when they are directly bound to a control?

It would be nice to programatically dump all properties of all forms to text files.

Answer 1

Right-click on the query in the database window and select "Object Dependencies" This should give you the list of forms that host it as a sub-form.

This only works if you have Track Name Autocorrect Info turned on which is the default. I personally turn this off as it bloats the db.