Not Allow Future Date

[Guest]

I have a form where people are checking their co-workers work and reporting
any errors they find. I have a date field that must be in the past. Is
there a way to have an error message appear if a future date is entered?
Thanks for all of your help.

 

[Allen Browne]

Open the table in design view.
Select the date field.
In the lower pane, set the Validation Rule property to:
Is Null OR <= Date()

More information about validation rules:
http://allenbrowne.com/ValidationRule.html

 

[BruceM]

In the After Update event for the date textbox (I will call it
txtCheckDate), something like:

If Me.txtCheckDate >= Date Then
MsgBox "Date must be in the past"
Me.txtCheckDate.Undo
Cancel = True
End If