The descriptions in column 1 all start with a word such as
"Truck 18" or "Pumper 22" or "Engine 44" like how Fire Department vehicles are identified. And I save a code from column 2 in my table. Like code "0062" is for "Truck 18", code "0024" is for "Pumper 22".

But the reason I don't get confused when the user types in a value into the combobox, it is because the user types a number only such as "414" or "79" or "191" which represent ambulance vehicles.

You know what, I think I just found the problem as I am typing this response. I should be saving column 1 in my table instead. I see you point about typing a number and getting it confused with a code because they could be equal.

Let me see if that is the solution. Thanks for making me think. I guess I was to tired last night and too confused. If I only save column1 I could drop the code altogether, but that means my table which used to save a Char 4 now has to save a Char 25 to accomodate some of my long descriptions such as "Med Chopper 3". But I think you understand my problem.