Filtering a subform using a combobox in the main form

[cafe_jay]

I did this...

A And B And (C Or D or E)

But its reading it like this...

(A And B And C) Or D Or E.

I am going to try this C Or D Or E And A And B, hopefully like this it reads from left to right

 

[pbaldy]

This may help make sure the SQL is coming out correctly:

http://www.baldyweb.com/ImmediateWindow.htm