Locked Property [Access 2003 VBA Language Reference]
The Locked property specifies whether you can edit data in a control in Form view. Read/write Boolean.
expression Required. An expression that returns one of the objects in the Applies To list.
The Locked property uses the following settings.
|Yes||True||(Default for unbound object frames) The control functions normally but doesn't allow editing, adding, or deleting data.|
|No||False||(Default for all controls except unbound object frames) The control functions normally and allows editing, adding, and deleting data.|
Use the Locked property to protect data in a field by making it read-only. For example, you might want a control to only display information without allowing editing, or you might want to lock a control until a specific condition is met.
The following example toggles the Enabled property of a command button and the Enabled and Locked properties of a control, depending on the type of employee displayed in the current record. If the employee is a manager, then the SalaryDetails button is enabled and the PersonalInfo control is unlocked and enabled.
Sub Form_Current() If Me!EmployeeType = "Manager" Then Me!SalaryDetails.Enabled = True Me!PersonalInfo.Enabled = True Me!PersonalInfo.Locked = False Else Me!SalaryDetails.Enabled = False Me!PersonalInfo.Enabled = False Me!PersonalInfo.Locked = True End If End Sub