Use the Before Update Event in Microsoft Access VBA

In this Microsoft Access tutorial, I'll show you how to use the Before Update event to cancel the editing of a field if certain conditions are or are not met. For example, you can see if a record is "locked" by a manager and require a password before unlocking it. 

Michaela from Winston-Salem, North Carolina (a Gold Member) asks: I watched your InputBox video a few days ago. That was awesome. Thank you. Is there any way to just password protect a few specific fields on a form, instead of the whole form? I want everyone to be able to see fields like credit limit, but I only want managers to be able to edit them if they're locked.

Pre-Requisites

• Gray Out Fields: https://599cd.com/GrayOut
• InputBox: https://599cd.com/InputBox
• AfterUpdate: https://599cd.com/AfterUpdate

Recommended Course

• Access Developer 24: https://599cd.com/ACD24

Links

• Simple Security: https://599cd.com/SimpleSecurity
• Access Security Seminar: https://599cd.com/Security
• Access Data Encryption Seminar: https://599cd.com/Encryption

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, beforeupdate, before update, locked, enabled, password protect fields, Confirm Changes using the Before Update Event, BeforeUpdate vs. AfterUpdate, Cancelling a Record Update with BeforeUpdate Event