Filtering data

N

Nancy

Hello -

I am very new to access and have a question:
I have a screen with 20 fields on it. My users would like to enter
information into eirther a id or name field and query the database based upon
what they entered.

I have been using Filter by Form, but feel as if I am barking up the wrong
tree. Is there a way to do this.
 
A

Allen Browne

If you have outgrown Filter By Form, here's a couple of options:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
and:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The first one is very easy to set up and flexible to use, but it filters on
only one field at a time.

The second one takes some more time to code, but let's the user choose a
combination of fields to filter. It is also a great learning experience,
e.g. can be applied to reports to.
 
Top