Trying to locate the table the report field is pulling its data from.

[redhonda9834]

I have a msaccess 2010 report I am viewing. The database has many linked tables and I would like to find out which fields point to which tables in the report. If i click on the field and select control source it doesn't tell me what table it is looking at. Any ideas where I would go?

[JoeM]

If you look at the Record Source of the Report Properties, it will tell you where the data is coming from. If there are multiple tables involved, it is most likely coming from a query (unless you are dealing with Subreports within your Report or DLOOKUP values). So then you would go that query to see which tables those fields are coming from.

[redhonda9834]

Ahh yep there it is. Thank you for the help.

[TommyK]

Yup, reverse engineering the report/form is the only way to find this info. Wouldn't it be great if Access had a 'tree' that would show you a diagram of where data comes from?

I've had to create these myself by screen printing the Navigation Pane, then drawing traces backwards from Report / Form through the queries, back to the original Tables.

MicroSoft? Are you listening?

[CJ_London]

Wouldn't it be great if Access had a 'tree' that would show you a diagram of where data comes from?

Have you never used Object Dependencies > Objects that I depend on?

[TommyK]

Have you never used Object Dependencies > Objects that I depend on?

HEY! that's pretty slick. I'd never seen that before. Thanks Ajax!

However, it doesn't seem to work with Union Queries.

It does give you the next level dependencies. Not quite a tree, but getting there.

This will be helpful when doing my spring cleaning, i.e. deleting orphaned objects.