Confusion on Combo Box

P

Peter

I have 2 controls. One is warehouse code and the other is warehosue name. the warehouse code is a combo box with 5 columns. The Column Widths is 0";0";0";1";2". Column 3 is the warehouse code and column 4 is the warehouse name. It shows perfectly in the pull down list. But no matter which row is selected, the combo box (warehouse code) always displays column 3 of the first row. But the warehouse name displays the correct column of the selected row.

It seems this is strange. Any idea?
 
V

Van T. Dinh

Are both ComboBoxes bound to the same Field in your Form's RecordSource?

--
HTH
Van T. Dinh
MVP (Access)




Peter said:
I have 2 controls. One is warehouse code and the other is warehosue name.
Click to expand...
the warehouse code is a combo box with 5 columns. The Column Widths is
0";0";0";1";2". Column 3 is the warehouse code and column 4 is the warehouse
name. It shows perfectly in the pull down list. But no matter which row is
selected, the combo box (warehouse code) always displays column 3 of the
first row. But the warehouse name displays the correct column of the
selected row.
 
P

Peter

Yes, they are. I changed the Column Bound to 5 and solved the problem. But I don't know the underline reason.
 
Top