Insert, No Edit

[Dorci]

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.

 

[MacDermott]

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

 

[Marshall Barton]

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?

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

 

[Dorci]

A variation of that code worked. Thanks for the advice!

 

[Dorci]

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!