Null Value Query

  • Thread starter Thread starter bomantas
  • Start date Start date
B

bomantas

Hi peeps! I made a Query-By-Form and got most of it working the way
want except I can't make it run if there are null values. I want it t
display all the records if my combo box doesn't contain anything. I d
have other combo boxes that may contain criteria, so I would like th
query to still search by those criteria. My coding in the underlyin
query is

[Forms]![Form1]![Combo3] Or [Forms]![Form1]![Combo3]Is Null

This however makes the query return no records. I think because it i
looking for records that have that particular criteria blank. Can som
one help
 
Bomantas,

The syntax of the criteria expression you have used is correct, and
should do what you want it to. Well, that's one way to do it, anyway.
Maybe if you post the full SQL of your query, someone might be able to
spot the problem.
 
Back
Top