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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling data from a linked SQL table 2
Find table used in form 3
Access How to remove a non-existent field from a form's Field List 0
Can't create a report from my query in Access 1
DELETE FROM a table WHERE... 1
Access Create option group without using wizard? 2
Adding background color to an existing field in a table 2
How to calculate form field 1

Top