Many Many Checkboxes

[Guest]

I've got about 20 checkboxes...for now. They are divided into 4 groups. I'm
anticipating that the users may want to add more checkboxes in the future and
I do not want to keep adding new fields to my table. The checkboxes are set
up in a questionnaire type of usage. Any suggestions?

 

[Guest]

Look into using optiongroups.

 

[Guest]

I looked at optiongroups, but I don't think it will work for my case. The
user must be able to check more than one checkbox in each group.

 

[Guest]

I checked into multi select listbox but that is beyond me.

I think that you could use combobox as label over datasheet subforms
something like this --
Group A Group B Group C Group D
Pecan Orange Cabbage OJ
Walnut Peach Radish Lemonade
Peanut Apple Water

Use an event to append to table where item is selected.
Use two tables with a one-to-many relation.
Table1--
ID - autonumber
Title - text

Table2--
ID - number - long interger
Group - text
Selection - text

 

[Guest]

Also see my post 8/10/2005 Finding a record in a main form