Option buttons for Yes/No's in table

[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

 

[PC Datasheet]

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.

 

[Yolli]

That worked. Thank you

-----Original Message-----
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.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com



.