enable/disable all controls on form

[madEG]

Hello. I have a form with a million little buttons on it (don't get me started, I didn't design it! - heh)...

Depending upon which user is running the mdb, I would like all but 16 (of the 80 or so) objects/controls disabled/enabled. I would like to autodisable all the controls, then enable the subset (or all of them) depending who the current user is.

SO in short, other than individually disabling/enabling the many items, is there a magic command for vba, similar to enable *.* for controls [silly e.g., but I hope you get my point...]

Thoughts!

Thanks!
-madEG

 

[madEG]

Doh! Sorry, re-googled with new terms and found a very helpful newsgroup.

http://www.access-programmers.co.uk/forums/archive/index.php/t-76691.html

Thanks anyway...

 

[Moniker]

Much more recent example (I answered this one eight days ago).

Enable/Disable all Controls function