Locking a record on a form

[Sturgis76]

Hello,


I have a form with various fields and a check box to lock the record. In the header of the form I have 2 search boxes that get locked when the box is checked. I would like to be able to still use the search boxes when the record is locked. Also I would like to add a yes or no message box when you check the box to confirm that the user wants to lock the record. Here is the code I have so far. Thank you for your help.

Private Sub Form_Complete_Click()

End Sub


Private Sub Form_Current()
If Me![form complete].Value = True Then
Me.AllowEdits = False

Else
Me.AllowEdits = True
End If






End Sub

[pbaldy]

You can toggle the setting in the focus events of your search textboxes.

[Sturgis76]

What code would you put in the got focus box?

[pbaldy]

Toggle the AllowEdits property.