Programming

T

TaylorLeigh

We have special purchases that be made by certain organizations. We give
them a date by which to reply. I want the order entry form to alert me if
the date of order entry if after the cut off date.
 
J

John W. Vinson

We have special purchases that be made by certain organizations. We give
them a date by which to reply. I want the order entry form to alert me if
the date of order entry if after the cut off date.
Click to expand...

Alert you... when? Under what circumstances to you want this alert?

I'm GUESSING that you could use code like this in the Form's BeforeUpdate
event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
If Me![CutoffDate] < Date() Then
MsgBox "The cutoff date has passed", vbOKOnly
Cancel = True
End If
End Sub

Since you chose not to post any information about where the cut off date is
stored, what the form is based on, or what you mean by "date of order entry"
this is rather a stab in the dark...
 
Top