Help with If Statement

[JDU]

In the code below the first part of the if statement executes just fine;however, when the field is blank it doesn't. Can someone tell me what's wrong.

If (RstInputAllCALApplicants.Fields(&quot;txtCALDate&quot <= Form_frmInputAllCALApplicants.txtDeleteDate) Or (RstInputAllCALApplicants.Fields(&quot;txtCALDate&quot = &quot;&quot Then
RstInputAllCALApplicants.Delete
End If

 

[vbajock]

Test for null first:

if isnull(RstInputAllCALApplicants.Fields(&quot;txtCALDate&quot) then

'do something else

else

If (RstInputAllCALApplicants.Fields(&quot;txtCALDate&quot <= Form_frmInputAllCALApplicants.txtDeleteDate) Or (RstInputAllCALApplicants.Fields(&quot;txtCALDate&quot = &quot;&quot Then
RstInputAllCALApplicants.Delete
End If

end if

 

[JDU]

Thank-you