Prevent backdating with Pop up Calendar

[vlc123]

Does anyone know how to prevent backdating in a date field when using a pop up calendar?

 

[missinglinq]

What kind of 'popup calendar' are you speaking of here? Is this an ActiveX Calendar? A Form-based calendar? The native Calendar available for Date/Time fields in Access 2007/2010?

If one of the first two types, what code are you using after the date is selected, to assign the value?

Linq ;0)>

 

[Steve R.]

As a follow-up to missinglinq comments; what is meant by "backdating". For example, if the entry has to be the current date and no other, then you can lock the date field as use the DATE function to set the date (default value).

If there is a degree of latitude, you can use DateDiff for testing. In my case, when I receive a project I may not immediately enter it. So I have a test that asks for filing date verification should the received date be greater than seven days prior to the current date.

 

[gemma-the-husky]

in the datecontrols before update event just do

if mydate<date then
 msgbox "data cannot be before today"
 cancel = true
 exit sub
end if