Insert, No Edit

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

Guest

Access 2002: How can I allow editing of a particular field when a record is
first created, but not allow editing once the new record has been saved?
Thanks.
 
You can use the form's OnCurrent event procedure to run code like this:
If Me.NewRecord Then
MyField.Locked=False
Else
MyField.Locked=True
End If
 
Dorci said:
Access 2002: How can I allow editing of a particular field when a record is
first created, but not allow editing once the new record has been saved?
Click to expand...


How do you know that users will NEVER make a mistake
entering the field's value??

Use the form's Current event:

Me.controlname.Locked = Not Me.NewRecord
 
That worked. Thanks!
In the event the user makes a mistake entering the field's value, an
administrator can correct the value in the backend database. It's more
critical (and more likely) that the users do not accidentally change an
existing record's value as it is the key field. Thanks for the advice!
 
Back
Top