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

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" <(E-Mail Removed)> wrote in message
news:O%23wPj$(E-Mail Removed)...
>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
>
>
>

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:O%23wPj$(E-Mail Removed)...
> >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
> >
> >
> >
>
>
>

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?




"KARL DEWEY" <(E-Mail Removed)> wrote in message
news:69A76CB0-1421-4A39-93EF-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:O%23wPj$(E-Mail Removed)...
>> >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
>> >
>> >
>> >
>>
>>
>>

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.




"HotRod" <(E-Mail Removed)> wrote in message
news:O%23wPj$(E-Mail Removed)...
>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
>
>
>