Finding Field in Table

L

LaurieH

I am using a very complicated database created by someone else that contains
a multitude of different tables and forms. When I enter information into a
field on a form, how can I determine what TABLE that information is stored
in? I can see the NAME of the field, but can't find the TABLE information.
 
W

Wayne-I-M

Hi Laurie

Open the form in design view and open the propertes box. Check which
table/query the form is based on also check the individual control's
properties by selecting it then looking in the data column
 
J

John W. Vinson

I am using a very complicated database created by someone else that contains
a multitude of different tables and forms. When I enter information into a
field on a form, how can I determine what TABLE that information is stored
in? I can see the NAME of the field, but can't find the TABLE information.
Click to expand...

Open the Form in design view, and view its Properties. The first property on
the Data tab is the Recordsource - this may be just a tablename, or (more
likely) a Query name or a Query SQL string. You can click the ... icon by it
to see the query design grid. This should give you the table and fieldnames.

John W. Vinson [MVP]
 
Top