QBF Technique

[Stuart Grant]

I have been trying to use the QBF Technique. I downloaded the Microsoft
Support article illustrating the technique in Northwind and tried to
duplicate it. The article says that you must type the following criteria in
one line.
Forms![QBF_Form]![WhatCustomer] Or Forms![QBF_Form]![WhatCustomer] Is Null.
I cannot get it to work. When you click on the Search button, nothing
happens. When you go back into the Query in design mode, you find that
Access has split the criteria up into two lines. You edit, put it back in
one line exactly as the article says. Access changes it again.
What is wrong?
Stuart

 

[Stuart Grant]

The Search button has On Click - QBF_Macro which in turn runs the query. The
whole thing is exactly as in Microsoft Knowledge Base 304428 which very
specifically says that it MUST all be in one line.
Stuart

I have been trying to use the QBF Technique. I downloaded the
Microsoft Support article illustrating the technique in Northwind and
tried to duplicate it. The article says that you must type the
following criteria in one line.
Forms![QBF_Form]![WhatCustomer] Or Forms![QBF_Form]![WhatCustomer] Is
Null. I cannot get it to work. When you click on the Search button,
nothing happens. When you go back into the Query in design mode, you
find that Access has split the criteria up into two lines. You edit,
put it back in one line exactly as the article says. Access changes
it again. What is wrong?
Stuart

Two lines is fine since two lines of criteria are "ORed" rather then
"ANDed". Something else is the problem.

What is the code behind your search button?