Block all controls of a FORM and a SUBFORM through a command button

U

UTOPIAN

Hello to all!

How can I block all controls of a FORM and a SUBFORM through a command
button?

Thanks!

Utopian.-
 
J

Jeff Boyce

The basic concept is that you would use a procedure that cycled through all the controls on a form, checking to see if each was a textbox or combobox or listbox, then changing the .Locked property appropriately.

There are procedures available (?mvps.org/access) that do this ... ?EnableControls()?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Sorry, I meant Lock no Block....
 
Top