>Hi all.
>
>I'm wondering if anyone knows of a way to let a text box behave like a combo box....What I'm really looking for is a text that will one value but store a different value to a field.
>
>For example...I have a code table with a bunch of codes and an description of each code. The user will type the descripton of the code inthe text box. The text box will then look the appropriate code and store it in the field. I want to be able to roll back any chages. Is there a way to do this.
>
>
>TIA for any responses.
>
>Carl

Depending on your purposes you may have an unbound textbox which will perform a kind of lookup in it's Valid() method and replace the field with the value obtained from a lookup routine.