In Access 2003, do not allow users to change value of a field

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

Guest

I know this is an easy one, but I can't seem to figure this out. I want an
end user to be able to create a new record, but after the record is created,
there is a field that cannot be changed without a password. I need to be
able to use this field to filter, so "enabled" doesn't work. How can I set
the property of the field so that an end user cannot change the value without
a password?
 
On a form you can lock the control that is displaying the value of a field.

You can use the on current event along with the form's new record property
to Lock/unLock the control. Something like the following should work

Private Sub Form_Current()
Me.txtLinkTo.Locked = Not (Me.NewRecord)

End Sub
 
Back
Top