You can have this one-liner in the button click event:
Me.AllowEdits = Not Me.AllowEdits
That will work for the parent form. I'm sure you can work it out if subforms need a similar line.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have the following problem, I have created an Access database and have a main input form with several subforms for different project classes.
This form will be processed by different people in the future and is therefore susceptible to unwanted changes to the data entered.
My question now is the following. How can I block the form when it is opened?
And how can I then unlock them with a botton in the form to make entries?
Then the form should be blocked again by clicking the button again.
Unfortunately, I have failed to program this so far, so if someone could help me, I would be very grateful!
Thank you for any help in advance!
You can have this one-liner in the button click event:
Me.AllowEdits = Not Me.AllowEdits
That will work for the parent form. I'm sure you can work it out if subforms need a similar line.