Lock a field after data entry so value cannot be changed

  • Thread starter Thread starter Lori LeRoy
  • Start date Start date
L

Lori LeRoy

I have a form used for receiving where the receiver selects his/her name when
receiving product. Once they have entered their name I want to 'lock' that
field so it cannot be changed by anyone in that form at a later date. Any
ideas? Thank you!
 
Using the Current event of the form you could check if
it is on a new record and if not, lock the control.

Private Sub Form_Current ()

Me!YourControl.Locked = Not Me.NewRecord

End Sub

Replacing YourControl with the actual name of your text box,
combo box, etc.
 
That worked! Thank you very much.

Beetle said:
Using the Current event of the form you could check if
it is on a new record and if not, lock the control.

Private Sub Form_Current ()

Me!YourControl.Locked = Not Me.NewRecord

End Sub

Replacing YourControl with the actual name of your text box,
combo box, etc.
Click to expand...
 
Back
Top