Lock a field after update using code - Access 2000

[Sheldon]

Hi,

After data is entered into a field, I'm trying to lock the
field so only a supervisor can go in and change the data.
Is this possible? Thanks for your help.

Sheldon...

 

[Naresh Nichani MVP]

Hi:

Are you using Access Workgroup security?

If so you can give add permission to the General User but Update permission
only to the Admin user?

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Dina]

Private Sub ControlName_AfterUpdate()
ControlName.Locked = True
End Sub

 

[Sheldon]

Thank you.

-----Original Message-----


Private Sub ControlName_AfterUpdate()
ControlName.Locked = True
End Sub




.