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

  • Thread starter Thread starter Psims
  • Start date Start date
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.
 
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.
 
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

Find table used in form 3
Access How to remove a non-existent field from a form's Field List 0
Pulling data from a linked SQL table 2
DELETE FROM a table WHERE... 1
Can't create a report from my query in Access 1
Access Create option group without using wizard? 2
Disappearing Fields in a form 1
Access Access - Is it possible to repeat fields in a form? 1

Back
Top