Tracing Report Source 1

[BobDe]

I inherited a very complex Access db and I am wondering (this is probably naive on my part) if there is an easy way to trace what table or query any report in the db is being drawn from? Any help will be gratefully accepted. Thanks!

 

[luceze]

In access 2000 you can use the documenter (tools\documenter). Just select the reports that you wish to view information on and then you can identify the record source in the properties section. If there are sub reports the record source for them will be listed separately.

 

[luceze]

In access 2000 you can use the documenter (tools\documenter). Just select the reports that you wish to view information on and then you can identify the record source in the properties section. If there are sub reports, the record source for them will be listed separately.