I have a form with 3 option buttons, and about 50 labels, textboxes, and buttons. Is there a way I can group some of these objects so that way when I select an option, some of the objects get disabled or enabled and I only have to use vba to say which group is enabled or disabled? Or will I have to write vba for each object and have 1000 lines of code?

link|improve this question
feedback

1 Answer

I would tackle this kind of problem with custom collections in Access. I've written at length on that here:

How to Use Controls Collection in Access 2003 and VBA

link|improve this answer
Thank You for your help. – Dan Sep 23 '11 at 12:02
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.