question about how to handle mulitple check boxes

[Daniel M]

I have a form that has mulitple checkboxes. I am finding that it is going to
be hard to maintian as new boxes (options) are added. I know i can use a drop
down box instead but the users and i prefer the checkbox look. I have 10-15
on the form that are then put on a report and printed. As i add more i have
to add more to the queries, forms, reports, vb code. it is getting to be a
mess.

Without changing to dropdown boxes is there anyway to group them that may
make them more managable? I have one set of check boxes that display visible
if option A i selected in a drop down and another set of boxes displayed if
option B is selected.

Any ideas or suggestions would be appreciated.

 

[Beetle]

This is the exact reason why you *shouldn't* use checkboxes to store
preferences or data involving choices. There is really no way to make
it more "manageable". You will always have to make design changes to
your tables/queries/forms/reports any time you add another choice.
See this link for more discussion;

http://allenbrowne.com/casu-23.html