Confusion on Combo Box

[Guest]

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?

 

[Van T. Dinh]

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

--
HTH
Van T. Dinh
MVP (Access)

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.

 

[Guest]

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