Hope you get an answer to that 'cause I didn't.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.Why don't you just toggle the 'AllowEdits' and 'AllowDeletions' properties on the form?
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.
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!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:
Then when you click a 'save' button do the opposite:Code:Private Sub cmd_Edit_Click() Me.AllowEdits = True Me.AllowDeletions = True End Sub
It just seems to me you are going through an awful lot of programming when this may suffice...Code:Private Sub cmd_Save_Click() Me.AllowEdits = False Me.AllowDeletions = False End Sub