Access 2007 is not null problem

  • Thread starter Thread starter nybaseball22
  • Start date Start date
N

nybaseball22

Hello. I recently converted an Access 2003 database to 2007 and had a
macro that had conditions built in. These worked in 2003 but do not
work in 2007. The example:

Conditions:

If Forms!MainForm!List1 is not null
If Forms!MainForm!List2 is not null
etc

The database would apply the correct filter based on my selection in
several list boxes. Now when I execute the query, it only runs
correctly if the selection is made in the first list box, and if not,
it returns nothing.

Thank you.
 
it might work if you convert your code to:

if isnull(Forms!MainForm!List1) = false .................

ludovic
 
Back
Top