Lock Fields with Tag Property in Access

In this Microsoft Access tutorial I will show you how to create an edit mode that locks most fields on your form by default, but keeps specific fields like search combo boxes or notes unlocked and always editable. We will use the Tag property to mark which controls should be locked, and then loop through the form's controls in VBA to manage their Locked and BackColor properties efficiently, reducing the amount of manual coding needed in large forms. I will also show you how to use simple error handling for control types that don't have certain properties.

Ken from Rancho Cordova, California (a Gold Member) asks: I'm interested in having my form be read-only by default with an Edit button to make it writable. I just saw your videos about Edit Mode. In my case, I have a combo box in the header that selects a record, but it becomes frozen if I set the form's Allow Edits property to False. The only workaround I found is to set the Locked property for all the individual controls, but that's a lot of VBA if the form has many controls. Is this the best way to do it, or is there a better approach?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Edit Mode
• Tag Property
• For Each Loop
• Create Function

Links

• Find Record Combo
• RGB
• Immediate
• Error Handling
• Save Button

Recommended Courses

• Access Developer Courses

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 Diamond Sponsors - Information on our Sponsors 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

TechHelp Access, edit mode button, lock form fields, AllowEdits property, combo box locked workaround, loop through controls, Tag property usage, lock/unlock specific fields, LockFields subroutine, VBA For Each loop, control Locked property, subroutine for locking fields, dynamic form locking, gray out locked fields, BackColor property, On Error Resume Next VBA, debug immediate window, runtime error trapping, toggle edit mode, save button implementation, preventing accidental edits, user-friendly form security