Locking Records

R

Rick V.

Once you save a record, how can you lock it so that the
user can't mistakingly change the record? I am runnig
Access 2000.
 
C

Cheryl Fischer

If what you want to do is add new records but not edit existing records, you
can set the Allow Edits Property of your form to No.

hth,
 
R

Rod Scoullar

If you are referring to preventing the user changing data on a form you can
lock individual fields on the form by changing the Locked property to true
or prevent changes to any data on the form by changing the form AllowEdits
property to false.
 
Top