search form

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

Guest

In the past, I have used an excel spreadsheet with the AutoFilter function.
This puts a drop down at the top of each column, with options to sort,
filter, and custom filter.

I want to use something like this for my database's search form. Any
thoughts?

Thanks,
Steve
 
You have several filter options in Access.

You can click on any field and click the Filter By Selection (toolbar) to
limit the form to only records that match that value.

You can click the Filter By Form toolbar button to switch to a mode where
you can enter the limiting criteria.

You can right-click on any field to filter or sort.

In Access 2007, the right-click has lots of new useful options (such as
"Last week" for date fields.)

If you want something more obvious and don't mind writing some code, you can
create a search form with the boxes for the fields you think the user will
need to filter by. Here's a downloadable example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Finally, if you just one to search on one field at a time, you can implement
this solution with a copy'n'paste (i.e. you don't need to write any code:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html
 
Back
Top