On Wed, 27 Jan 2010 15:24:01 -0800, Jacqueline
wrote:

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

You may want to get one of the third-party programs which help document and
crossreference Access databases:

Free: http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com

Not all of these support A2007, and some may not be available anymore (my list
is rather old). Some more general resources (which may link to other such
programs) are at

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

--

John W. Vinson [MVP]