[AccessD] Syntax question

Lorraine,
Try swapping
If cmdPositiveEmail.Enabled = True And txtEmailDate.Value = Null Then
With
If cmdPositiveEmail.Enabled = True And IsNull(txtEmailDate) Then
I have had problems with variable = null in the past and IsNull seems to get round it
Paul Hartland





Message date : Dec 17 2003, 02:46 PM
>From : Christian, Lorraine 
To : accessd at databaseadvisors.com
Copy to : 
Subject : [AccessD] Syntax question
Good morning,

I can't figure this out.

Private Sub cmdNew_Click()
If cmdPositiveEmail.Enabled = True And txtEmailDate.Value = Null Then
MsgBox "You must send an email before leaving this record." & vbNewLine & _
"To send an email, click the email button."
Else
Call adhNavNew([Form])
End If

End Sub

On the above event even though cmdPositiveEmail.Enabled = True And txtEmailDate.Value = Null 
the routine pops to the else portion of this event. Can someone direct me on what maybe wrong?

Thanks

Lorraine




---------------------------------------------------------
This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies. 

---------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime