Dlookup problem

[sabavno]

Hi

I use a dlookup function to look up the value.

The question is if won't find a value in the table, would varRollup (which is variant) be null or it would just be the error?

varRollup = DLookup("TOPROLLUP", "TransitValidation", "[TRANSIT] = " & varTransit)

How can I check if no values were returned for varRollup?

 

[jebry]

Hi!

If Access finds no value which matches the criteria then a Null value is returned.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[sabavno]

But then

Why when I check

If not varRollup = null then
do stuff
else
exit
end if

even if varRollup is null the if statement still 'do stuff'?

 

[jebry]

Hi again!

The proper syntax is If IsNull(varRollUp) = False Then etc.

hth
Jeff Bridgham
bridgham@purdue.edu