You can't query the system tables for this information. In the system table
MSysObjects, you can find the names of all the forms and reports, but not
what fields are used. To do this, you'll have to use code.
Tell me, why do you want to do this? If it's just to find out which forms
and reports are affected by field changes, you should look into a product
called "Find and Replace" by Rick Fisher
(
http://www.rickworld.com/download.html). It's shareware, but you get extra
features for the ridiculously low registration fee.
--
--Roger Carlson
Access Database Samples:
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
