I've created a form and am having trouble getting the drop-down boxes to
behave like I want them too.

The user of the form should select an item from the drop down box, but I
want the result to be a code for the item. So, for example, if the user
chooses the item "black," once he/she tabs out of the field, the code "blk"
should populate that field. This will be true of most of the drop down boxes
in my form. I do not want to use the code itself in the drop down list,
because in most cases, the correlation will not be this simple.

I've tried a macro to accomplish this, and though the behavior is correct,
once the user moves out of the field, the result code (i.e. "blk") is added
to the list of available items in the drop down box.

Any ideas?