Yes, you can create a filter by using a combobox. There are two methods:
the first one is to collect data from multiple combobox into a cookie (the
easiest way; you can also add them at the end of window.location.href but
it's more complicated) and use parameterized queries for your stuff. More
If you don't want to dive into this cookie stuff, then here the second
method to filter your form:
First, create a combobox (or dropdownlist) and set its ListRowSource to a
query (recordset) returning the list of the names with their IDs; then set
the ListBoundField to the IDs (primary key) for this list and the
ListDisplayField to the field for the names.
Then, in the GroupLevelProperty, set the GroupFilterControl to this
dropdownlist and the GroupFilterField to the same field as the ID above..
The primary key field for the recordset of the page should also be the same
field. Now, the combobox will server as a filter for the named.
I don't know if you can use this second method with two or more comboboxes.
There is also a newsgroup about DAP: m.p.access.dataaccess.pages . Old
messages can be searched or accessed via Google:
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC