Binding Values from a Table to Option Buttons contained in an Option Group

[faerewing]

Hello,

I am trying to bind a value from a table in my database to an option
button on a form. I am building an evaluation form where I need to
assign a value to each button to be able to calculate a total score.

For example, the first question would be "The Instructor was
knowledgeable of the topic."

You would then have to pick "Exceeds Expectations", "Meets
Expectations", "Does Not Meet Expectations" or "Not Applicable". Each
of the choices has a value assigned and that value is different
depending on the question.

I have set up a table that has the values I need but I do not know how
to bind the option button to an individual value.

 

[faerewing]

I also want the value for the option button clicked to return to
separate table that records these answers for reporting purposes.

 

[Bill Mosca, MS Access MVP]

Wouldn't a combo or list box be more suiting to your needs?

 

[Douglas J. Steele]

Duane Hookom's "At Your Survey" should show you what you need.

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'