Multiple Selection Option Box

G

Greg

I would like to create an option group that allows multiple selections. Is
there such a feature?

Thanks in advance for your help

Greg
 
K

Klatuu

sure, the easiest way is to create the option group using the option group
wizard. I don't know if there is a limit on the number of options in an
option group, but if you get to that point, the option group is the wrong
control.
If the option group is already established, then just add another option
button, toggle button, or whatever you are using and give it the next value.
For example if you already have opt1 = 0, opt2, =1, then add opt3 and give it
the value 2.
 
G

Greg

Thanks for your response...

Actually, I need the ability to select 1 or more options within the same
option group....

Hopefully this makes sense....

Thanks again...
 
A

Allen Browne

An option group, by definition, allows one option to be selected.

If you need to allow for multiple options to be selected, you need to create
a related table to store the options for the record in the main form. You
can select multiple options on different rows of the subform, typically by
using a combo box.

Example:
Client table (one record per client):
ClientID primary key
Surname
...

Color table (one record per color name):
ColorID primary key

ClientColor table (one record for each color a client likes):
ClientID which client this record is about.
ColorID which color this client likes.

This one-to-many set of relations is the very core of how relational
databases work. For another example, see:
Relationships between Tables (School Grades example)
at:
http://allenbrowne.com/casu-06.html
 
Top