Which table is form from?

[jackmac]

Hi all,

Hopefully an easy question. I've been asked to look at an Access 2003 table and modify it. It's been a very long time and I've got a little stuck.

I have a form on it and I need to know which table the fields are looking at. There are several hundred tables and a few forms so knowing which table would make things easier.

Any ideas how to identify which table is involved please?

TIA

Jackmac

 

[pbaldy]

The record source property of the form identifies it's source (table or query).

 

[jackmac]

Thanks for the reply.. I'm still a little confused.

In Design View, I've right-clicked on a field and the box that pops up offers me 'Control Source' but not record source.. no joy there I'm afraid.

Right click on the form brings nothing.. am I missing something?

 

[pbaldy]

You're describing properties of a textbox. I'm talking about properties of the form itself. The textbox control source is the field in the table. The form record source is the table. Open a form in design view and without clicking on anything, open properties. That should be the form's property window.