Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Create an Option group Bound to different fields?

Discussion in 'Information Technology' started by HotRod, Jul 28, 2006.

  1. HotRod

    HotRod
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. HotRod

    HotRod
    Expand Collapse
    Guest

    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" <NOSPAM@youremail.com> 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
    >fields but still have the option buttons recognized as a group?
    >
    > Question 1 save answer is either
    > QA1a
    > QA1b
    > QA1c
    > QA1d
    > QA1e
    > QA1f
    >
    >
    >
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    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" 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" <NOSPAM@youremail.com> 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
    > >fields but still have the option buttons recognized as a group?
    > >
    > > Question 1 save answer is either
    > > QA1a
    > > QA1b
    > > QA1c
    > > QA1d
    > > QA1e
    > > QA1f
    > >
    > >
    > >

    >
    >
    >
     
  5. HotRod

    HotRod
    Expand Collapse
    Guest

    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" <KARLDEWEY@discussions.microsoft.com> 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
    > 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" <NOSPAM@youremail.com> 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
    >> >fields but still have the option buttons recognized as a group?
    >> >
    >> > Question 1 save answer is either
    >> > QA1a
    >> > QA1b
    >> > QA1c
    >> > QA1d
    >> > QA1e
    >> > QA1f
    >> >
    >> >
    >> >

    >>
    >>
    >>
     
  6. HotRod

    HotRod
    Expand Collapse
    Guest

    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" <NOSPAM@youremail.com> 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
    >fields but still have the option buttons recognized as a group?
    >
    > Question 1 save answer is either
    > QA1a
    > QA1b
    > QA1c
    > QA1d
    > QA1e
    > QA1f
    >
    >
    >
     

Share This Page