How to use query or macro to filter form

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

Guest

I've set up a form with a command button that runs a parameter query. The
query works - but rather than using the query as a filter to narrow the
records in the form (or in a separate form), it simply provides the query
results in datasheet form.

How can I get Access 2003 to use the query results to narrow the records in
a form?
 
Hi,



To reduce the visible records, already downloaded, to a subset of these
records, use a form filter, either from the toolbar, either through VBA
code. You can also remove the filter to get back to the records already
downloaded.

A query reduces the number of records being firstly downloaded from the
database.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top