I have a form tham that is used to scroll through data, and occasionally edit some of that data. The form is initially set to AllowEdits = False, AllowAdditions = false. If the I want to edit data I must hit a button that unlocks editing. In the OnCLick event of that button I have the following code:
When the app open I can edit, but I have set the allowedits to fase in the on load event
and when I hit the button again, to lock the edits, I can still edit.
What part am I missing?
Blue in the face!
Thanks
Code:
If Me.LockUnlockbtn.Caption = "Edit Locked" Then
Me.AllowEdits = True
Me.LockUnlockbtn.Caption = "Edit Unlocked"
Me.LockUnlockbtn.BackColor = RGB(255, 0, 0)
Else
Forms!RoboMasterEntry.AllowEdits = False
Me.LockUnlockbtn.Caption = "Edit Locked"
Me.LockUnlockbtn.BackColor = RGB(238, 201, 0)
End If
When the app open I can edit, but I have set the allowedits to fase in the on load event
and when I hit the button again, to lock the edits, I can still edit.
What part am I missing?
Blue in the face!
Thanks