Option group and datasource

[bdubuc]

Is it possible to have an option group get its values from a table?

I am building a survey application and I would like to have a form where I would show the question and the available answers would be presented in an option group (radio buttons).

Tables look like this:

table Questions
QuestionID
QuestionText

table Answers
QuestionID
AnswerID
AnswerText
AnswerNumValue

Thanks guys and have a great Mundial !!!

 

[RichMorrison]

I believe this can be done.

You would need some code that gets all the rows from tblAnswer for a specific QuestionID and puts them in a Recordset.

Then you would read each row and copy the Answer Text to a label next to an option button.

You would have to synchronize Answer #1 to Label #1, 2 to 2, etc.

I don't know if you can move AnswerNumValue to the Option Value of an option button during run time.

HTH,
RichM