method of 'locking' entries

[wardy]

hello all,, any help again,, would be greatly appreciated,,
i have a very simple database that has a number of tables that are all interelated by a key called JobCard,, a number of forms act as an interface to add to the data on the tables,,, what i would like to know is,, is there a method that allows the user to 'lock' the data in a filed once that filed or record is considered complete?
many thanks

 

[missinglinq]

To lock a given field (YourTextBox in this example) on your form, once it contains data:

Private Sub Form_Current()
If IsNull(YourTextBox) Then
  YourTextBox.Locked = False
Else
  YourTextBox.Locked = True
End If
End Sub