![]() On the “On Click” property click on the little black down arrow / triangle and select “Event Procedure”ĩ. In the tools section of the “Design” tab click on the item called “Property Sheet” and select the “Event” tabĨ. Go back to your form and select the command button called “btnLocked”ħ. On a new line directly between the two lines above add the followingĦ. Click on the three dots next to the little black down arrow / triangle – this will open up the VBA window and you should see the following:ĥ. On the “After Update” property click on the little black down arrow / triangle and select “Event Procedure”Ĥ. In the tools section of the “Design” tab click on the item called “Property Sheet” and select the “Event” tabģ. The following tutorial shows you how you can use VBA to lock or unlock a text box on an access form following the update of another text box or after the click of a button.įor this tutorial you will need to create the following fields /controls on your form:Ī text box called “textbox1” (the box that will be updated)Ī text box called “textbox2” (the box that will be locked)Ģ. ![]() ![]() APPLIES TO: ACCESS 2007, 2010 (UNTESTED IN EARLIER VERSIONS)
0 Comments
Leave a Reply. |