Hi guys, OK, I admit - newb question - but I'm pretty desperate as my googling hasn't dispayed the help I need.
I have a form that has a series of option button groups. I woudl like these optinos to change data to be displayed in a report. So I have something like this:
Form1:
Opt1=1
Opt2=2
Opt3=3
Report:
ResultOfOptions
Sure I can make ResultOfOptions display the value (1-3), but I would like to assign text values to these numbers. Then when the report prints it will say Apple, Orange, or Banana instead of 1, 2, or 3... I've played w/the code a bit but it's been so long that I've done anything in access or VB that I can't seem to get this one =/
Thanks in advance!!
I have a form that has a series of option button groups. I woudl like these optinos to change data to be displayed in a report. So I have something like this:
Form1:
Opt1=1
Opt2=2
Opt3=3
Report:
ResultOfOptions
Sure I can make ResultOfOptions display the value (1-3), but I would like to assign text values to these numbers. Then when the report prints it will say Apple, Orange, or Banana instead of 1, 2, or 3... I've played w/the code a bit but it's been so long that I've done anything in access or VB that I can't seem to get this one =/
Thanks in advance!!
