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
[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