Double dlookup failing

[JeroenMioch]

Dear programmers,



In having trouble combining two dlookups.
The first dlookup checks of a date in a certain field is greater the todays date, this works as intended.
But when i add another to check if the datestring is empty it fails.

If DLookup("Miva_tot", "tblMinderValide", "Pnummer = '" & Me.Pnummer & "'") >= Date Or DLookup("Miva_tot", "tblMinderValide", "Pnummer = '" & Me.Pnummer & "'") = "" Then 
        Me.slvMIVA = True
        Else
        Me.slvMIVA = False

I tried is Null, "0" and "" but on any occasion it returns false while the record selected should return true

Greetings,

Jeroen

[pbaldy]

Try

IsNull(DLookup(...))

[JeroenMioch]

Hi Paul,

It works !
Thanks a million

Greetings, Jeroen

[pbaldy]

Happy to help!