I have a date field on an Access form and I do not want the user to be able to put in a date that occurs in "last week's reporting period" (explained below).

Our reporting period goes from Monday to Sunday........so for example since tommorrow is Monday (the start of the new reporting period), I do not want the user to be able to put in a date for the prior 'Monday to Sunday' period.

I wanted to see if there was a way to enforce this using VBA code.


Thanks.