How do i convert a value in to a text word?

[slenish]

I am having some trouble doing a conversion. What I have is a combo box where if you type in the word All it knows to pull all the records. But because on the query I have running behind the input form the query knows that in order to pull All the records you have to type in "*". So what I did was put in a code on the back end that converts the word All to equal "*", but at the same time in the combo box it will display the symbol "*" is there a way i can get the word "All" To stay in the combo box but still equal the value "*" for the back end??

[colintis]

I'm a bit misunderstandin g on what are you trying to do. As I can see, are you trying to capture a query result into the combo box? If so, just simply put the query into the row source property of the combo box.

If my guess is wrong, can you show us the code of what you have done?

[ChipR]

Depending on how your query is set up, you can for example use a (hidden) text box on your form as the input instead of the actual combo box. Either on the after_update event of the combo box, or just before the query is run, grab the combo box value. Copy it to the text box, but if it is 'All', write '*' into the text box.