Basic Form Information

[mparker1113]

I have forms in a database that I am looking at. How can I tell which table the forms are connected to?

Easiest thing, I know. Help much appreciated.

-Mike

 

[andrew93]

Hi Mike

Go into the form design, click Edit -> Select Form, click View -> Properties -> Data Tab -> Record Source -> this is the table (or query) that the form is linked to.

It often helps to prefix your table names with "tbl" or "T_" and queries with something like "qry" or "Q_" so that you know what you are looking at within queries, forms, reports & VB scripts.

HTH, Andrew