How do I find what table a field name from a form is in?

P

Psims

I've looked in properties in design view on the form and can't seem to find
out what table the field is linked to. Any help would be appreciated.
 
B

BruceM

A table can be the form's Record Source. A control such as text box can
have a Control Source from the Record Source table. If you look at a text
box properties and see that it has a Control Source from a table, the Form's
Record Source property will tell you which table that is. A query may
include several tables, so if the Record Source is a query you may need to
open the query in design view to discover the table or calculation to which
a control belongs.
That's about as much as I can suggest based on your cryptic question. If
you need more information, include some more details.
 
J

Jeanette Cunningham

Psims,
on the Property dialog, on the Data tab, look at the Control Source.

Jeanette Cunningham
 
Top