DLookup Help

[DataFanatic]

Question regarding return value from DLookup.. The help states that DLookup will return NULL if no data is returned.

I have used the example: dim varx as Variant and then checked varx for NULL value. I can't seem to get the check to work. I want to direct the user to renter a correct value in the event of NULL.

Can anyone shed some light on the proper evaluation of varx being a null value.

Thanks

 

[jrbarnett]

What code have you got so far?

John

 

[kevinf2349]

Should you be using DLOOKUP at all? Can't you just code..

If IsNull(varx) Then
MsgBox "Whoops...", vbExclamation
End If


AIRC DLOOKUP looks up a value in a table...and isn't very efficient at that either

 

[DataFanatic]

Thanks for the repsonses.
John here is what I am doing.
Dim Varx as variant
varx = DLookup("[Name]","Database","[Id]='" &

 & '"

The DLookup returns the value i'm tryimg to find.
I wanted to do some error checking and changed it to the code included here.

I can't seem to have it fall into the If NULL condition.

 

[DataFanatic]

Kevinf2349

I was checking for If varx = null then...

I tried the if isnull(varx) and that solved it.

thanks to both for your effort to Help ME!!!