Lock and un-lock form based on a control event.
Posted on 2004-09-14
I have an Access database of employee records. There is a form where the user will enter a social security number. The after update event of that box will cause a macro to run which will fill in some of the fields on the form and on a sub form. What I’m having trouble with is the following: Upon opening the form, I want the sub form to be locked so the user can’t enter data in it until after a SSN has been entered on the main form. After a SSN has been entered, I want the sub form to unlock and the SSN field to become locked so the user can’t change it again. How do I do this?