Rich, but that won't toggle back to AllowEdits=False.
Angello try this....
Create a cmdButton and put "LOCK RECORDS" in it's Caption. Then use this OnClick Event
cmdbutt_Click()
If cmdbutt.Caption="LOCK RECORDS" Then
Me.AllowEdits=False
cmdbutt.Caption="UNLOCK RECORDS"
Else
Me.AllowEdits=True
cmdbutt.Caption="LOCK RECORDS"
End If
The command button works in that it toggles between LOCK RECORD and UNLOCK RECORD... but you can still edit the record no matter when...
What am I doing wrong?
Ignore my post before..... I have changed the cmdbutton to UNLOCK instead of LOCK...
It works to the point that I can't edit the record until I push UNLOCK..then I can edit. Put once I push LOCK..it does not lock...
What else do I need to do?