D
Dave Elliott
I have a control on my form named WorkDate (No Space)
It's control source is Work Date (Space Between)
On the update event or change event I need to check for a date within the
range below.
If out of this date range , then Message Box, Cancel if possible and not
save until criteria is met.
There is an unbound textbox named AnyDate on my form with it's default value
set to Date()
=CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2 ' Criteria One, The Start
Date
=CDate([AnyDate])-(Weekday(CDate([AnyDate])))+4 ' Criteria Two, The End Date
It's control source is Work Date (Space Between)
On the update event or change event I need to check for a date within the
range below.
If out of this date range , then Message Box, Cancel if possible and not
save until criteria is met.
There is an unbound textbox named AnyDate on my form with it's default value
set to Date()
=CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2 ' Criteria One, The Start
Date
=CDate([AnyDate])-(Weekday(CDate([AnyDate])))+4 ' Criteria Two, The End Date