Re: Help with populating a questionnaire!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Start by using the web to search for tutorials that explain how to populate
a control with data. You can start with tutorials that discuss how to
populate DropDownList controls with data because those tutorials are easy to
find. They will help you get insight into how the database is accessed and
how the data is bound to a control's list items. It seems you will also need
to learn how to generate a control dynamically because you may never know
how many RadioButtons each question will need.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP 43°2'17"N 88°2'37"W : 43°2'17"N 88°2'37"W


<standon410@xxxxxxxxx> wrote in message
news:1157749666.287485.238670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,
I'm trying to develop a questionnaire...basically a user can pick one
of 5 questionnaires they want to use, and based on their choice, those
questions will appear in their form.

So the database table contains all the questions/radiobutton selections
in one table (well, a view), and they are related to their respective
questionnaires based on a form ID.

Now, How do I populate a RadiobuttonList, AND label above the
radiobuttonlist, so that the the label would hold the question, and the
radiobuttonlist would hold the selections for that question...and this
would be based on form, and based on question (ie, some questions only
have 3 choices, some have 2, etc). I guess I just need some help
starting off the code for both the design, and SQL. Would I use the
Repeater for this? I've never used this before, so I'm not sure how to
implement it. Anyway, if anyone has suggestions, please let me know!!
I need help! Thanks!

Here is some sample data of the table:

QID Question FID Radio_Caption Radio_Value
1 1) Please rate your knowledge FormA very little knowledge 1
1 1) Please rate your knowledge FormA little knowledge 2
1 1) Please rate your knowledge FormA some knowledge 3
2 2) Does anyone in your family FormA Yes 1
2 2) Does anyone in your family FormA No 2
3 3) Genes are made of FormA DNA 1
3 3) Genes are made of FormA RNA 2
3 3) Genes are made of FormA proteins 3
21 1) Have you ever had testing FormB Yes 1
21 1) Have you ever had testing FormB No 2
22 2) The religious affiliation FormB Buddhism 1
22 2) The religious affiliation FormB Catholic 2
22 2) The religious affiliation FormB Hinduism 3



.

Relevant Pages

  • Re: Changing the parameters of a form
    ... Since you stated the control source of my "Days' textbox "should be the ... But now nothing will populate, ...
    (microsoft.public.access.queries)
  • Re: You tried to assign the Null value...
    ... focus to and drops down the control in question. ... The JOIN effectively makes the RouteID a required field. ... or is there an option somewhere to tell Access to quit enforcing the JOIN ... I can open the table directly, populate the field, move to another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Option Group: Auto Update
    ... the control to a listbox, the listbox automatically populated all of the ... I tried using a continuous subform with an option button and a label in the ... table to populate the subform. ...
    (microsoft.public.access.formscoding)
  • Re: Changing the parameters of a form
    ... populate a control that is bound to the field you want to store the number ... ' Inputs: StartDate As Date ... Dim intCount As Integer ... it also appears your expression is in the control source of a text ...
    (microsoft.public.access.queries)
  • Re: Trying to figure out how to link two controls
    ... After you set your combo box datasource, you should check if their are rows, ... > the first is a comboBox the second is a datagrid. ... > from the combobox control what populates the datagrid. ... > to populate its referenced table in the dataset. ...
    (microsoft.public.dotnet.languages.csharp)