Is not null statement help

[ScottTN]

I am trying to use a If then statement to make sure that a field is not null based on a combo box value. Thanks Scott!

__________________________________________________________

If Me.cboStatus = "Complete" Then
Me.txtDateComplete IS NOT NULL STATEMENT HERE???

Else

End If

 

[WayneRyan]

Scott,

If Me.cboStatus = "Complete" Then
If IsNull(Me.txtDateComplete) Then
MsgBox('...')
End If
Else

End If

HTH,
Wayne