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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Birthday Script 4
Validate 3 Text Fields - Urgent Need to finish by Monday 2
Update a date field in sub-form from dates fields on main form 1
how to do this bit of code better? 2
calc date of birth in query 1
Data doesn't show up in bound fields 4
Check mandatory fields using VBA not working properly 12
Checking a forms fields for null 1

Back
Top