What table/query is this form using?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table form that I used the wizard to set up. Now (a few days
later) I am trying to find which table or query is being used by this form.
I can't find it in the form design, nor can I go back far enough in the
'edit' process to find the source. Is there a command I can write to list
the forms and their table/query source?

Thanks
 
Usually, the wizards create an SQL statement and set the form's recordsource
to it, rather than saving the query itself. Even if you save your own
query, and use it during the wizard, it still uses its own SQL statement
instead of your saved query.
 
Open the form in design view. Click on Properties icon on toolbar. Click on
Data tab.

The Record Source will show you the table/query on which the form is based.
 
Actually I had tried this as well as looking for the SQL for tis statement.
It does not give me the option to look at the SQL and the Record Source is
blank-- maybe becasue the pivot table is 'generated' through excel??? Any
other ideas?? Thanks !
 
Back
Top