Option Buttons for Rating?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

THANKS IN ADVANCE!!

I'm setting up a form where the user will rate various items on. say a 3
point scale. Let's say it's High/Med/Low.

I'd like to use 3 grouped option buttons for each item, and I'd like the
response to be recorded on a table (whose columns are named by Item number),
as H/M/L or 3/2/1.

I've got as far as creating the buttons and grouping them so that only one
can be checked at a time....but I'm confused about what to do next...How do I
make each button click translate to the right value?

I've used similar buttons in exce, and so I thought this was going to be easy!
 
When you say you've created the buttons and grouped them so that only one
can be checked at a time, do you mean that you've placed them in an option
group? If so, bind your table's field to the option group, and the field
will get whatever value is active in the group.
 
I'm not sure I'm following, Duane.

Are you saying that Stilla does have 3 fields and should only have 1 (in
which case yes, I agree), or are you simply saying that you're afraid that
Stilla might have 3 fields (H, M and L) and is expecting the table to have
True for H and False for the other 2?

It sounds to me as though there's only a single field that's supposed to
store 1, 2 or 3. However, it does sound as though there's a single row with
Field1 containing the option for choice 1, Field2 containing the option for
choice 2 and so on, which of course is wrong.

Stilla: If you're still following this, do you want to post back with
details of your tables?
 
I read it the same way Duane did. I think she has 3 fields, one for each
possible response.
Stilla, you need only one field to hold the value chosen.
As to making the Option Group return a value, each option button (check box,
whatever) has a property named Option Value. You need to set a numeric value
for each button. When you query the value of the Option Group (Frame), it
will return the Option Value of the currently selected Option Button.
 
THANKS you Guys!!! Yes, I got it, I figured it out..oh my gosh, and it
WORKS!!!

I used an option group box to group three boxes and lo and behold! clicking
each of them puts a different value (1,2,3) into the ONE column (oops, field)
in my table.

This is very COOOL!

Thanks!
 
Interesting how semantics works. I see "I'd like the response to be recorded
on a table (whose columns are named by Item number), as H/M/L or 3/2/1" as
storing one of 3 possible values in a single field, but with a repeating
group.
 
My apologies for causing a semantics controversy. I don't have the right
lingo down!

I was able to accomplish what I needed to - I'm starting to like
Access...not as much as I like Excel yet...but who knows?

I'm excited! My form is looking good. When I finish, I know there's some
way that I can hide everything else (except the form) before I send it to
whoever will be using it, and I'm assuming "lock" everything about the
design, so nothing gets messed up. But, I'll learn about that when I get
there...

Thanks for everything - you guys are great!

Stilla
 
Back
Top