Date field if IsNull

  • Thread starter Thread starter dbl
  • Start date Start date
D

dbl

Hi I have a date field called "LicHeldFor" the following code works if the
LicHeldFor field is blank but when you enter a date it still gives the same
result the msgbox. What am I doing wrong? If you delete the DateOfBirth
part of the code it still doesn't work yet if you delete LicHeldFor part of
the code it does work.

The LicHeldFor is a Date/Time field and so is the DateOfBirth field.


If IsNull(Me.LicenceHeldFor) Or IsNull(Me.DateOfBirth) Then
MsgBox "You cannot proceed"

Me.ClaimFormReceived = "NO"
Me.ClaimFormReceived.SetFocus
Else
 
Back
Top