Can I save and reuse a form query?

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

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.
 
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.
Click to expand...

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]
 
Back
Top