Hi Kamal,

Yes, this works fine but it isn't quite what I need.

I want the user to enter the prefix and have the prefix show up in the combo box. Then when the user moves out of the control, I want the publisher for that prefix to be visible in the combo box.

For example:
User enters RH in the combo box with a width of 2. RH shows up in the combo box.
User moves to next control and Random House appears in the combo box with a width of 200.

If I change the rowsource and put the publisher preceding prefix in the lostfocus method, then I lose the selected value and displayvalue.

Any ideas?