Option Group - Multiple Selections

F

FrankM

I'm using an Options Group on a Form. The Form is used to update a Table. I
wanted to use Option Buttons to enter various information. However in the
Option Group you can only select one Option Button. Is there a way to select
multiple Option Buttons within an Option Group?
 
J

John Vinson

I'm using an Options Group on a Form. The Form is used to update a Table. I
wanted to use Option Buttons to enter various information. However in the
Option Group you can only select one Option Button. Is there a way to select
multiple Option Buttons within an Option Group?
Click to expand...

No; an Option Group control has only one value.

More to the point, you do NOT want to store multiple values in one
field - violates the fundamental principles of relational design! Use
*ANOTHER TABLE*, related one to many to this table, and a Subform.

John W. Vinson[MVP]
 
D

david epsom dot com dot au

Yes, you can put multiple check boxes or radio buttons on a
form: Yes, you can draw a rectangle around them.

No, it's not called an 'option group' unless it's a group
of options that you can only select one value from.

(david)
 
Top