This is great code Marcia, thanks for sharing.

My pleasure < s >. As I told Naomi, it I find it useful in cases were the ControlSource takes its value from a standard lookup most of the time. It allows the user to use a "write-in" ( other ) value when it is occassionally required without cluttering up the list of standard choices.