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

  • Thread starter Thread starter UTOPIAN
  • Start date Start date
U

UTOPIAN

Hello to all!

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

Thanks!

Utopian.-
 
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....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Access Reference Subform's Control 0
Subform Requery Criteria 1
Subform Data Entry Setting 0
Access Manage Attachments linked to a SubForm 0
Access Main form/Subform Navigation 0
Forms: linking child/master fields on a non-embedded subform 4
How can I avoid the advise 1

Back
Top