Option buttons - Only One!

H

HServ

I'm making a survey in the "Strongly agree, agree, disagree, etc." style
with option buttons under those headings for each question. The only problem
is that more than one option button can be pressed at once so a person can
agree and disagree at the same time. If I choose to index the option with no
duplicates, all the questions have to be answered the same. How can I make
each question have allow only one choice but allow each question to have a
different answer? Thank you
 
R

Rick Brandt

HServ said:
I'm making a survey in the "Strongly agree, agree, disagree, etc."
style with option buttons under those headings for each question. The
only problem is that more than one option button can be pressed at
once so a person can agree and disagree at the same time. If I choose
to index the option with no duplicates, all the questions have to be
answered the same. How can I make each question have allow only one
choice but allow each question to have a different answer? Thank you
Click to expand...

Your field structure is incorrect. For mutually exclusive selections you
need only one field where you store one value for Strongly agree, agree,
disagree, etc..

The typical interface for this is RadioButtons within an OptionGroup frame.
The OptionGroup will automatically enforce the mutually exclusive aspect and
each RadioButton will have a numeric value that will be transferred to the
OptionGroup control as each selection is made. Thus in your table you will
actually store numbers (1="Strongly Agree", 2="Agree", etc.).

You then use a translation table in queries to get the text value or use
something like the Choose() function...

=Choose(FieldName, "Strongly Agree", "Agree", "Disagree")
 
D

Dirk Goldgar

HServ said:
I'm making a survey in the "Strongly agree, agree, disagree, etc."
style with option buttons under those headings for each question. The
only problem is that more than one option button can be pressed at
once so a person can agree and disagree at the same time. If I choose
to index the option with no duplicates, all the questions have to be
answered the same. How can I make each question have allow only one
choice but allow each question to have a different answer? Thank you
Click to expand...

The option buttons should be part of an option *group*, and the option
group should be bound to a field in your table. The individual option
buttons themselves should not be bound -- if they are part of an option
group, the group itself has the value corresponding to the option button
that is chosen.

The easiest way to create an option group is to let the Option Group
Wizard build it for you. However, if you've already got a bunch of
buttons created, you can create a new option group, then "cut" those
buttons, select the group frame (very important), and paste the buttons
into it. After doing that, you'll have to adjust the Option Value
properties of all the buttons.
 
H

HServ

Thank you Rick, that worked well

"Thus in your table you will
actually store numbers (1="Strongly Agree", 2="Agree", etc.)."

Since my form isn't linked to a table where will the selection values be
stored?

Thanks

Lis
 
R

Rick Brandt

HServ said:
Thank you Rick, that worked well

"Thus in your table you will
actually store numbers (1="Strongly Agree", 2="Agree", etc.)."

Since my form isn't linked to a table where will the selection values
be stored?
Click to expand...

If your form is not bound then the values won't be stored anywhere. Being
bound to a table is a requirement for data that you want saved. If you
don't need it saved then don't worry about any of that part of my response.
 
Top