date no changing allowed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This should be simple but I cannot figure it out:
A date is entered on a form (from a table) I just want to lock it once it is
entered the first time. Another words, someone enters a date, I don't want
anyone to be able to change it.
 
In the form's current event:

Me.SomeDate.Locked = Not Me.NewRecord

The user will then be able to enter dates for new records; however, once the
record is updated, it can't be changed.
 
PERFECT - I cannot thank you enough......




Klatuu said:
In the form's current event:

Me.SomeDate.Locked = Not Me.NewRecord

The user will then be able to enter dates for new records; however, once the
record is updated, it can't be changed.
Click to expand...
 
Back
Top