Hopefully a quickie? :)

[Coatezy]

I am trying to do a simple if statement (well probably simple for you guys) but im having a few difficulties.
I want to check after update field

If its after 16:30 and today’s date has been entered then display a msg box..

If before 16:30 and today’s date then no action and the same for if after 16:30 and a future date is entered..

So kind of along the lines of

If “time” >=16:30 & me.collectiondate = “todays date” then msgbox ”error message” end if

Any ideas guys?

Tom

 

[DJkarl]

If time <#16:00:00# AND me.collectiondate = Date Then
  msgbox "Error"
end if