Re: Queries that store particular table
select the database tools tab
select the required table (don't open it)
click on object dependencies
this will show queries/forms/reports which use the table as a recordsource.
It will not show forms/reports with combos or list boxes using the table as a rowsource, nor textboxes using a domain function on the table, nor will it look at VBA to see if you have referenced the table in code.
If you need to go to this level of detail you will need a special tool - there are a number around - take a look in the code repository or google online
A little thanks goes a long way. If you have found this post useful, please tick the thanks button