option button - use text instead of numeric value in my query/report

[dbertanjoli]

Hello,
I am not sure what cateogory to choose for this question but I would greatly appreciate your help.

I have 5 buttons in my option group:
1. very often
2. often
3. occasionally
4. rarely
5. never

I have to produce a report using description of each button in my report, not numeric value. I heard something about global variable but I am not sure how to do it.

Many thanks,
Debbie

 

[spasticus]

hey

im not sure if this will work copy and past - you might need to change it a bit.

try using:

select case option_group_name
case 1
usage = "very often"
case 2
usage = "often"
end select

you'll only need a global variable if you use usage somewhere else in you code (i think) if you do you'll need to declare it at the top of you code - not in any sub (i think) use dim usage as string.