[badnap]

I am using a table in a form that based on what is listed in the nomunclature feild I can lock the required feild but not all the required feilds will be locked only the ones I specify. The code I am using is below. Please can you give an advice as to why this code is not working.

Private Sub Required_GotFocus()
If Form!NOMENCLATURE = "12RE59*" Then
Form!Required.Locked = True

End If
End Sub

[OBP]

Have you tried using On Current event procedure instead of the Gotfocus?

[OBP]

This - Form!Required.Locked = True
should be - Forms("Required").RecordLocks = 1 to lock all records of the underlying table when the form is open.
Or Forms("Required").RecordLocks = 2 to lock only records being edited by other users or on the form.
See Access VBA Help on RecordLocks Property
.