Roi
Thank you so much for your help. It works. I really appreciated your help.

I have a little more question. Are there anyway, I could make the combo show only when I want to add a new record. So when my users cruise around, it won't show all the time unless when they click the arrow down. Now it shows all the drop down list every time I moved my mouse to the field.

Thanks again.

Have a great weekend.