Option Group value to text string help

[m17347047711116]

I have an option group on my form now and the user selects the option desired, the value in the option group is then defined as a numeric value.

I now need to put an hidden unbound box on my form that will look at the option group value and convert the value to text to be used for my criteria in my query.

not sure how to write the code for the list box

option group value IIF[Department] =1 then"Shipping =2"Printing"

 

[R. Hicks]

You really don't need the hidden txtbox.

Have a look at the Choose() function in Access Help files. You can use it in the criteria section of your query to convert the numeric value to the desired text.

HTH
RDH

 

[m17347047711116]

Thank you

Thanx
works like a charm

 

[R. Hicks]

No problem .... .... You are welcome.

RDH