Good day,
I am trying to make a filter form:
2 Combo box
1 subform with data to filter
Problem: If I use OR in criteria it works, subforms gets populated. But if I use AND it does not work.
Attached you will find an example with AND.
If you select A and AR result should be A and AR.
What is happening?
Thanks.
NOTE: I know that the "requery" is on each OnClick event of the comboboxes. I should use a button to requery, but I am more concerned about the criteria.
I am trying to make a filter form:
2 Combo box
1 subform with data to filter
Problem: If I use OR in criteria it works, subforms gets populated. But if I use AND it does not work.
Attached you will find an example with AND.
If you select A and AR result should be A and AR.
What is happening?
Thanks.
NOTE: I know that the "requery" is on each OnClick event of the comboboxes. I should use a button to requery, but I am more concerned about the criteria.