Where is the query used?

[Reyno]

I just started a new job and took over a database that has been in production/use for about six years...quite robust, but also quite confusing.

I need to add some functionality to some forms to accomodate for changes in fiscal year (FY), and I don't want to build a new form for each year (as my predecessor did) rather add a field in the form for the user to select the FY and have the query narrow search results based on the selected FY. My problem is that I want to know which and how many of my 100+ forms use the query that I'm considering changing. Is there a way for me to find this out?

I've considered a "parameter" form that comes up when the user enters the db in which the user selects the FY, and then going into each individual query and filtering the FY based on my parameter form, but that would take a long time given the number of queries in the db.

Any thoughts?

 

[Rickster57]

Query

Yes there is, atleast in access 2003 (don't remember about 2000).

In design view click on the query of interset to highlight it. At the menu on top go to View, Object Dependencies and a form will pop up to the right. You have an option of two choices...Objects that depend on me or Objects that I depend on. Objects that depend on me should show you all the forms that use that query.

By the way, if you decide to get the MS Access Certification, this was on the test.

Hope this helps.