Form : Lock all controls in form

[dek]

Hi,



I have a field named 'Locked' (which is a check box) in my form that is bound to the master table.

The checkbox stores TRUE or FALSE in the table.

I would like to lock all control properties in the form and subform (except for the 'Locked' control) automatically when selecting the LOCKED control and on leaving the record.

A simple VBA solution using the event 'after update' would be appreciated.

Thanks

[June7]

Only way I know is to address each control and set its Locked property. Like:
Me.controlname.Locked = Me.[Locked]

Place all these lines in a Sub that can be called from the AfterUpdate and the OnCurrent events.

[vt800c]

Since the LOCKED control would be either True or False, why not set the default 'Locked' property on each control to me.[locked]? (or forms!formname.locked, whichever is correct...)

[kennejd]

I think vt is partially right....but I believe the solution will involve looping through each control on the form after update and on current. Here's a link that gives a pretty good example: http://access.mvps.org/access/forms/frm0004.htm