Restrict Date Field?

[Peggy M]

I have a date field on a form which is tied to a table
for the "Date" field in that table.

I want to restrict entries into that field to be either
the current date, or at least have to lie within the past
5 days of the current date. It will prevent typos of the
critical date field in my table.

How can i do that?

I dont want to have a "default" value for the field set
to "=now()", i dont want to do it that way, since the
date field is only used when another field on the form is
used.

thanks in advance

 

[JudithJubilee]

Hello there,

You can put a validation rule on the Date field in the
Table:

=DateAdd("d",-5,Date()) And <=(Date())

Hope this helps
Judith