During the past few years there was something in my development I tried, but failed so far.
1.My development has more than 200 forms, each form has an "Enable Button", all forms are similar, see first image.
2.I want every form when opened, not to allow editing or deleting by the normal capturer.
3.When a user with permission click on "Enable" it must allow editing and deleting. No help needed now.
4.The settings under the Data Tab on a form controls this.
5.Every form in my app has the VBA as in Image 4, It set Allow Deletions and Edits = False.
6.Clicking the Enable button then change Allow Additions and Edits = True. Which should allow the user to make changes now.
Results required.
1. Opening any form, edits and deletions should not be allowed on the form or Sub Form.
2. Additions should be allowed.
3. 1. After clicking "Enable", Edits and Deletions must be allowed on the Form and Sub Form.
Image 1 = Form
Image 2 = Data Tab of the Sub Form
Image 3 = Data Tab of the Main Form
Image 4 = VBA on the Main Form