code will run using And IsNotNull

[Guest]

I have the following event procedure on the close event of a form the code
works fine if I only use the first part If (Me.OrderStatus) = "Cancelled" Then
DoCmd.OpenForm "CancellationForm"
End If
End Sub
If I try to run as shwon below it halts
Private Sub Form_Close()
If (Me.OrderStatus) = "Cancelled" And IsNotNull(Me.txtDateConfirmed) Then
DoCmd.OpenForm "CancellationForm"
End If
End Sub
If I try just the the following it also halts
Private Sub Form_Close()
If IsNotNull(Me.txtDateConfirmed) Then
DoCmd.OpenForm "CancellationForm"
End If
End Sub
Any suggestions would be gratefully received

 

[Guest]

Try

If Not IsNull(Me.txtDateConfirmed) Then

Instead of
If IsNotNull(Me.txtDateConfirmed) Then

 

[Guest]

Thanks Ofer that did the trick I new it would be a simple mistake on my part