Problem with Query By Form

[Scott]

Hi,

I'm trying to work through the example included in "How to use the query by
form (QBF) technique", MS article 304428 but am having some difficulties
getting the correct results.

When I enter the following criteria "Forms![QBF_Form]![WhatCustomer] Or
Forms![QBF_Form]![WhatCustomer] Is Null" in the criteria cell, it appears to
be accepted on one line. The query runs a few times okay but eventually it
"blows up" and the last part of the expression (after the Or operator) is
placed in another Field cell and "Is Null" is placed in it's Or criteria
cell. I'm confused as to how/why this is happening and haven't a clue how to
fix it. I've been through the exercise MANY times but can't prevent this from
happening. It also occurs with this criteria "Forms![QBF_Form]![WhatEmployee]
Or Forms![QBF_Form]![WhatEmployee] Is Null"

Thanks for your help...
Scott

 

[jimati]

Put Forms![QBF_Form]![WhatCustomer] in the "Field" section of your query and
put "Is Null" in the criteria section.