Filter function like Excel

[Lydia]

Hi,

Access 2007 comes with similar filtering function as those in Excel, which
is pretty neat. In a table or a form in datasheet view, at the top of each
column, a drop down box is automatically there for you to filter records by
selecting one or multiple records.

I wonder if there is avaible codes that I could borrow and recreate the same
kind of function in Access 2002-2003, since not every user in my group has
Access 2007 and would appreciate this filtering funciton.

Thank.

 

[Allen Browne]

Not exactly the same, but here's one that's just copy'n'paste:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

It consists of a combo where you choose the field to search, and a text box
where you enter the value to find.

In practice, there are just a handful of fields on any form that you would
want to offer for filtering, preferably in any combination. This does
require you to write some code, but here's an example of how it's done:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html