Criteria: OR works, AND does not works

[Surka]

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.

 

[pbaldy]

You can't use the .Text property in your criteria; it requires focus, which obviously they can't both have.

 

[vbaInet]

Amended. See attached.

In addition to what Paul said, the LIKE operator is not necessary.

 

[pbaldy]

You must be really be bored?

 

[vbaInet]

You must be really be bored?

You guessed right.

 

[Surka]

Thanks both

 

[pbaldy]

No problem.