Create an Option group Bound to different fields?

[HotRod]

I have created a survey and the answer to Question one can either be button
1 or 2 or 3 etc. - 6 but only one. I want to use option buttons / radio
buttons to get the answer and then if option 3 is picked save a 1 in field
QA1c. I need to create a new field for each answer instead of just saving
the #3 like the wizard wants me too. How can I bind the anwser to different
fields but still have the option buttons recognized as a group?

Question 1 save answer is either
QA1a
QA1b
QA1c
QA1d
QA1e
QA1f

 

[HotRod]

OK I've managed to get a block of Radio buttons to work but how do I bind
each radio button to a different field?

 

[Guest]

Sounds like you are thinking Spreadsheet. Yhere is no need to store the same
information in additional fields as it can be displayed in a form or report
using IIF statements.
You can if you just got to store the data run an update query using IIF
statements. Update for field QA1a would be IIF([YourOptionGroupField] =
1, 1, 0)
Update for field QA1c would be IIF([YourOptionGroupField] = 3, 1, 0)

 

[HotRod]

I need to store teh boolean value in seperate fields so that it can be
merged with additional data and used in an SPSS syntax program that was
created a few years ago. I really don't want to change the the format now.
Since I have a group of Radio buttons working how can I pass the selected
radio button value to the table?

Sounds like you are thinking Spreadsheet. Yhere is no need to store the
same
information in additional fields as it can be displayed in a form or
report
using IIF statements.
You can if you just got to store the data run an update query using IIF
statements. Update for field QA1a would be IIF([YourOptionGroupField]
=
1, 1, 0)
Update for field QA1c would be IIF([YourOptionGroupField] = 3, 1, 0)

OK I've managed to get a block of Radio buttons to work but how do I bind
each radio button to a different field?

 

[HotRod]

Another thing that may work is how can I get the value from an option button
and pass it to a check box? I might be able to run this all in a small VBA
code?

I've tried Option276.value but it doesn't work, how can I tell if the option
button is selected.