Autofilter for Access 2003 (as in Excel)

G

gwolfgang

I have a database with one ID-field and NN number of text fields

Database Setup
-----------------------
ID [AutoNumber]
Field1 [Text]
Field2 [Text]
Field3 [Text]
....
FieldNN [Text]

Filter needed
-------------------
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.

Your assistance would be very much appreciated!!
 
D

Duane Hookom

You can build this with a continuous form and multiple combo boxes in the
form header. Or, you can wait for Access 2007.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter for Access 2003 (like in Excel) 1
Possible to link fields in a form to narrow selections? 4
Excel Macro to use cells as a autofilter 0
how to catch values from a texts to use it as values 3
Receiving field has no value error when it does 1
Filter by form - empty drop down list 3
Field Dependency 0
Import Text File Into Access 0

Top