Option buttons for Yes/No's in table

  • Thread starter Thread starter Yolli
  • Start date Start date
Y

Yolli

I have a table that has multiple Yes/No's.
I am creating a form that has option buttons for each
one. The reason I am using option buttons is because I
want the user to select only one. However, I can not
figure out how to group them together. I guess because I
want the user's selection recorded in the table.
Please help!

TIA
Yolli
 
Your tables are not set up correctly! Whatever you want the option buttons
for you have that attribute spread across several fields. You need to put
that attribute into a separate table and use one field for the attribute.
Say the attribute is Category and you have five categories. You need a
category table that looks like:
TblCategory
CategoryID
Category

CategoryID will be 1 to 5.

Then in the table where you need to identify the category of something, you
need a CategoryID field. To enter the CategoryID you then use an option
group that lists the categories 1 to 5. The option group will have a value
between 1 and 5 depending on which category you check. In an option group,
you can only check one of the five categories.

The option group control is in the toolbox; be sure the wizard is on when
you create the control.
 
Back
Top