using a option box but outputting a word value to a subform

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

Guest

I have a form that I am using option boxes to get a strict input from the
user. However, I would like to output the choices from that form into a
subform but with values (words) instead of numbers. Does anyone have any
ideas?

Thanks, Chris
 
There are a couple of options. One would be to put code in the option group
After Update event that would put the value in the control on the subform:

Dim strRetVal as String
Select Case Me.opgOptions
Case is = 1
StrRetVal = "One Thing"
Case is = 2
StrRetVal = "Another Thing"
Case is = 3
StrRetVal = "Something Else"
End Select
form!MyForm!MySubForm!txtBox = strRetVal

It may be worth cosinderingt changing the option group to a combo box. If
you create it with two columns, one for selection and one for the data to
load, it might be easier.
 
Back
Top