How to find the source query?

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

HI

After I have created a form based on a query, is there a way to find which
query it was based on?

If I make any changes to the query, will it reflect in the form?

Thanks
Ramesh
 
Hi!

Yes, if you change the Q it WILL reflect in the form! That´s the whole idéa
with linking a form to a source (table, query).

You can find the rowsource, which the form is based on, if you open up the
form in design view and open up the form properties (can be find under
View). Select tab <Data> top row is your data source and should show you the
name of the query on which the form is based!

// Niklas
 
Thanks a ton, Niklas.

I have been getting tired re-creating the forms everytime, I change the
query or I forget which query!

Some relief!

Warm regards
Ramesh
 
Back
Top