Checkboxes LOCK form Useless

[Micron]

Why don't you just toggle the 'AllowEdits' and 'AllowDeletions' properties on the form?

Hope you get an answer to that 'cause I didn't.

[irish634]

Hope you get an answer to that 'cause I didn't.

Sorry. I inadvertently skipped over your post.... I didn't think anyone suggested it.
Much simpler.

[Micron]

Sorry.

NP. I do it all the time. It wasn't really meant to solicit an response from you as opposed to the one to whom it was originally asked.

[ortizimo]

The only thing I found using this DB in 2003 and 2016 was that not using the split-form will NOT lock the entire DB. Otherwise the old DB I made under 2003 originally works fine under split-form. Not sure why but I made it back in 2006 so there may be "bad/novice" code in there that lets it work fine. Investigating this will take more time than I have to post results here. If no one objects I will close this as resolved. Thanks for all your help on the matter.

[ortizimo]

Why don't you just toggle the 'AllowEdits' and 'AllowDeletions' properties on the form?

In design mode, set the form properties:
AllowAdditions = True
AllowEdits = False
AllowDeletions = False

Then just toggle them:

If you have an 'edit' button do something like this:

Private Sub cmd_Edit_Click()

    Me.AllowEdits = True
    Me.AllowDeletions = True
    
End Sub

Then when you click a 'save' button do the opposite:

Private Sub cmd_Save_Click()

    Me.AllowEdits = False
    Me.AllowDeletions = False
    
End Sub

It just seems to me you are going through an awful lot of programming when this may suffice...

i am sort of new at this and therefore I dont know all the short cuts ai can use. I will try this one and see if I can consolidate the code better. thanks for your help!