Filter with a combo box using multiple criteria

_Nickel_

Registered User.
Local time
Today, 13:00
Joined
Nov 11, 2003
Messages
31
I have a form which I can filter using a combo box. The form is based on a query whicht looks up the criteria for one field in the content of the combo box. This is what is what I use in criteria field to look up the combo box's value:
[Forms]![NameOfFormWithComboBox]![ComboBoxName]
The combo box gets its values from a table containing the same values as the field that I want to filter by can have.
Now this works fine for filtering the form so that only records with the value "A" in my field "X" are shown. What I also need though is to be able to show all records that have either "A" or "B" as the value in field "X".
Can anyone tell me how to do this?

Thanks
 
I think you need a multiselect combo box. I have never used them but they are a regular on here. Do a search.
 
I think neileg means a multiselect listbox. Combo boxes can only have one selected value.

Another option might be to have multiple combo boxes.
 

Users who are viewing this thread

Back
Top Bottom