Confusion on Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Yes, they are. I changed the Column Bound to 5 and solved the problem. But I don't know the underline reason.
 
Back
Top