Autofilter for Access 2003 (like in Excel)

[gwolfgang]

I have a database with one ID-field and NN number of text fields. I
need to sort this data like Autofilter in Excel. In other words, when I
select Field1 a drop down menu appears where I can select one of the
entries in Field1. When I after that open the drop down menu for
another one of the remaining fields, only the entries matching the
filtered Field 1 values are shown.

How can this be achieved with MS Access 2003? I am surprised that
Microsoft does not include an Autofilter function in Access to start
with, so that no coding is necessary, at least for the standard cases,
like in Excel.

Database Structure: ID [AutoNumber], Field1 [Text], Field2 [Text,
Field3 [Text], ... Field NN [Text]

 

[J]

Hello Wolfgang:

I wish I could post screenshots here but oh well. Open your table. On
the main toolbar, to the right of the sort buttons, are the three
buttons you are looking for:

1) Sort by Selection (looks like a funnel and lightning bolt)
2) Filter by Form (funnel and form)
3) Apply Filter (funnel by itself)

For (1) just select the thing you want to filter for and click that
once. Unhighlight (3) to undo. For (2) you need to click it, then
type into the fields you want to filter (**or choose from dropdowns!
**), then hit (3) to see the appropriate records... click (3) again to
undo.

Microsoft's version:
<http://support.microsoft.com/kb/304263/EN-US/>

Cheers,
~J