Can I copy a query and change the form from which it is getting its
information?

Say I have a query to seach bolts. I like the format but want it to search
cars on a different form and give a seperate report. Can I copy the query,
rename it and point it to a different form and thus table?

Thanks

David

Sure. Copy the query, giving the copy some meaningful name. Open the
form/report and change the recordsource to this new query.

You may find it easier to manage, if you set the recordsource to the SQL
statement, rather than a saved query. Just open your query and go to View,
SQL; copy the SQL statement, open the form/report and paste the SQL
statement into the recordsource. Then you don't need to keep the query.


--
Joan Wild
Microsoft Access MVP

DDrowe wrote:
> Can I copy a query and change the form from which it is getting its
> information?
>
> Say I have a query to seach bolts. I like the format but want it to
> search cars on a different form and give a seperate report. Can I
> copy the query, rename it and point it to a different form and thus
> table?
>
> Thanks
>
> David