Trouble Validating Data Error 424 on Null Values

[bblekfeld]

I am trying to cross-validate data between different fields

it works unless I am asking about Null Values
Below is an example that would get me a "Runtime Error 424 Object Required". Sorry if this is something totally simple. Any help is appreciated



Private Sub AutoEmailChckbox_LostFocus()
If AutoEmailChckbox = -1 AND EmailAddress Is Null Then
MsgBox "Email Address Required for Auto Receipt"
End If
End Sub

 

[macca007]

try changing the email part of the code to.

If AutoEmailChckbox = -1 AND isnull(EmailAddress)Then
MsgBox "Email Address Required for Auto Receipt"
End If
End Sub

 

[rainsworth]

Thank you - I had the same problem.