Unanswered: Combo box - auto expand on field not bound
I have a combo box that has two fields from a query. The combo box is named vendid and the first column (vendid) is bound to this field. The second column is the vendname. The personnel would like to be able to start typing the vendname and it auto expand. Right now, I have the bound column as 1 and it will auto expand on that field. The problem is, how do I keep the vendid (column1) the bound field and have it auto expand on the vendname?