Jacqueline

Are you saying that your "queries, forms, and reports" rely on the values in
the table, rather than the fields (i.e., field name)? If so, could you
describe a bit more about how you're doing that?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Jacqueline" wrote in message
...
I have a table that contains codes for our distance learning classes. Our
state is getting ready to make a massive change to these codes.

I know I have queries that support reports and forms based on these codes.
Is there a way to track from the table to each query, form, or report that
the codes is used?
Any help here will really save me a lot of hours tracking this stuff down
or
waiting until something breaks.

Thanks
Jacqueline