Can I save and reuse a form query?

[Guest]

IF I query by form while i n form view can I save and reuse this.
I have a 4000 record DB in Access 2000. Many of these records are too old.
I want to do a query within the form and save it and use it as my main DB.

 

[John Vinson]

IF I query by form while i n form view can I save and reuse this.
I have a 4000 record DB in Access 2000. Many of these records are too old.
I want to do a query within the form and save it and use it as my main DB.

4000 records is TINY. 4,000,000 records is getting pretty big.

Note that a Query - whether from a query by form, or from a stored
Query - doesn't change what's actually stored on disk. "Using a query
as my main DB" is rather misleading - your database still contains
4000 records!

Why not just create a Query in the Query Design window, and use it as
the recordsource for your form?

John W. Vinson[MVP]

 

[Guest]

Thank you for your help -- this is the way I will go.