if...is null problem

[pb21]

Hi

I have to evaluate an is null. i have:

ArrDate = Me.Arrival_Date.Value
TodayDate = Now
If (ArrDate Is Null) Then
'date field is empty
do nothing

else

'do something

end if

it halts by saying object not found so how do i correctly evaluate the if?

regards
Peter

 

[namliam]

Is null is a 4GL (SQL) solution, the 3GL (Coding) solution is Isnull(field)

GL

 

[pb21]

THANK YOU so much it worked a treat.

 

[namliam]

But offcourse another happy forum member/customer

Happy to help