Which forms use which queries.

[polisasimo]

Hello,

I am brand new to Access. I am using 2013. I have a DB with a single table. One column is named "group" and contains a numeric value 1-50. Each record in the DB is assigned a group number. So some groups may contain 10 records some may contain 75. I have many reports each of which uses a query that selects records based on group criteria. For example report A will fetch all records with a group value of (1,5 and 15), while report B will return all records with a group value of (5, 7 and 15) etc etc.

I would like to add a column in the table "reports" that will allow storage of which report names each record will be returned on.

So using the example above let's say there are 3 records with a group value of 5. I would like to populate the "reports" column for these three records with a value of "A, B". Considering both report A and B return records with the group value 5.



I know I can use the object dependency pane to view each query and hand enter the criteria values into this new column. Is there a way to just query the DB to return all queries that use a particular where clause?

Thanks in advance for any help.

[June7]

How would you use the 'Reports' field?

Conventional approach for managing dynamic report is to have a single report and then apply filter criteria to the report when it is opened. This requires code.

Extracting the clause from a query object SQL statement would require advanced VBA code.