Create an Option group Bound to different fields?

I have created a survey and the answer to Question one can either be button
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12318-create-option-group-bound-different-fields.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
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

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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" wrote in message
news:O%23wPj$4mGHA.1208@TK2MSFTNGP04.phx.gbl...
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
>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] =
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
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" wrote in message
> news:O%23wPj$4mGHA.1208@TK2MSFTNGP04.phx.gbl...
> >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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
> >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" wrote in message
news:69A76CB0-1421-4A39-93EF-10F1597CDA36@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
> 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" wrote in message
>> news:O%23wPj$4mGHA.1208@TK2MSFTNGP04.phx.gbl...
>> >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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
>> >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" wrote in message
news:O%23wPj$4mGHA.1208@TK2MSFTNGP04.phx.gbl...
>I have created a survey and the answer to Question one can either be button
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
>1 or 2 or 3 etc. - 6 but only one. I want to use option buttons / radio
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12318
>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
>
>
>