Microsoft added a wonderful feature to Access 2003 that provides you with the capability to view information about object dependencies. It's called View Object Dependencies. Here's how it works:
To invoke the Object Dependency feature, right-click the report whose dependencies you want to view, and select Object Dependencies. The first time you perform this task for a database, a dialog appears prompting you to update object dependency information for the database (see Figure 10.1). After you click OK, Access updates the dependency information for the database and displays the Object Dependencies window on the right-hand side of the Access desktop (see Figure 10.2).
By default, the Object Dependencies window shows you the objects that depend on the selected object. This is a report (not a subreport), so no objects depend on it. You can click the Objects That I Depend on button to view the objects that the selected object depends on (see Figure 10.3).
You can click the node of an item to drill down to additional dependencies. In Figure 10.4, you can see that qryClients depends on tblClients. tblClients is a table and has no further dependencies.
Close the Object Dependencies window when you are finished viewing and working with object dependencies.