Toggle RecordLocks (1 Viewer)

[Angello Pimental]

How can I create a toggle button that will allow a user to lock or unlock the record for editing??

Does anyone know??

 

[Rich]

Me.AllowEdits=True added to a command button.
HTH

 

[KevinM]

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

HTH

 

[Angello Pimental]

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?

 

[Angello Pimental]

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?

 

[KevinM]

Sorry missed out Me.Refesh...


If cmdbutt.Caption = "LOCK RECORDS" Then
Me.AllowEdits = False
cmdbutt.Caption = "UNLOCK RECORDS"
Me.Refresh
Else
Me.AllowEdits = True
cmdbutt.Caption = "LOCK RECORDS"
Me.Refresh
End If

HTh

 

[Angello Pimental]

Brilliant.....
Thank you Kevin M