Find table used in form

[Zen]

I have a form that is not working and I need to edit the data. However I
can't find what table is used as I have opened every table and have not seen
one that has this field.

In the form I have gone to design view and right clicked on the text box to
get properties.
Under the Data tab, the control source dropdown shows what I believe to be
the field name, if I click the drop down it will show other fields to, I
just don't know what table it is using.

 

[Clifford Bass]

Hi,

While viewing the form in design mode, and while the properties window
is open, click on the black box in the upper left corner of the form. It
will now show the properties of the form instead of a field on the form. On
the Data or on the All tab look at the Record Source. This may be a table, a
query, or an actual SQL statement. If a SQL statement, it may use a table or
a query. If it turns out to be a query, you can view the query in design
mode to determine the source table of the query. I suspect you will find
that the record source uses a query and in that query the field you are
looking for has probably been aliased; that is given a different name for use
in the query. It would show in the top line of the query field grid as
follows:

Alias_Name: Actual_Name

Hope that helps,

Clifford Bass

 

[Zen]

I didn't see it in the design view properties but since you mentioned query
I started looking at the queries directly and finally found it!

THANKS.

 

[Clifford Bass]

Hi,

Glad to help you get pointed in a useful direction.

Clifford Bass