Date field

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,

I am using Access 2002. In my form I have a received date text box and a
reassigned date text box and a completed date text box. What I don't want
is to have the user input a completed date that is actual before the
received or reassigned date text box. For example - Let's say the received
date was July 25, 2005 and later it has an reassigned date at July 29, 2005,
but the user input July 1, 2005 in the completed date text box. I don't
want that to happen - My question is how do I prevent this? or have an error
message pop up. Any tips or suggestions will be appreciated. Thank you.
 
Use the BeforeUpdate event procedure of the *form* (not text box) to perform
the comparions.

Example code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.[reassigned date] < Me.[received date] Then
Cancel = True
MsgBox "Cannot be reassigned before received."
End If
End Sub
 
Back
Top