How to use query or macro to filter form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mla75 - 14 Feb 2006 20:56 GMT

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?

Reply to this Message

Michel Walsh - 14 Feb 2006 21:25 GMT

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

> 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
[quoted text clipped - 4 lines]
> in
> a form?

Reply to this Message