Use of radio buttons

[dkwong]

I am designing a course evaluation survey in an Access form. For each question, the respondent may choose one of 4 radio buttons: Excellent, Well, Fair, Poor.

The table that will store these values has the following fields: CourseID, QuestionID, Description, RatingID (links to Rating codeset table)

Depending on the radio button chosen, a number of 1, 2, 3 or 4 will inserted into the RatingID field.

What is the best way to accomplish this in a form using the existing objects and VBA Code. Are option groups in order? Thanks in advance.

 

[CautionMP]

It sounds like an option group is exactly what you need, the easiest way to do it is to make sure the "Wizard" is on before you drag an option group onto your form, then follow the steps to bind the option group to your RatingID field then follow the steps of adding the option names and the corresponding values that will be stored in your recordset.
I hope this helps and have a great weekend.