Lock a field after data entry so value cannot be changed

[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!

 

[Beetle]

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.

 

[Lori LeRoy]

That worked! Thank you very much.

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.