>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?
***Combo.GotFocus event
cValue=this.value
this.rowsource="table1.prefix,name"
this.boundcolumn=1
this.value=cValue
***Combo.LostFocus event
cValue=this.value
this.rowsource="table1.name,prefix"
this.boundcolumn=2
this.value=cValue
Edward Pikman
Independent Consultant