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.

I also want the value for the option button clicked to return to
separate table that records these answers for reporting purposes.
(E-Mail Removed) wrote:
> 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.

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

--
Bill Mosca, MS Access MVP


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I also want the value for the option button clicked to return to
> separate table that records these answers for reporting purposes.
> (E-Mail Removed) wrote:
>> 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.
>

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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>