combo boxes

[Chi]

Hi,

I have a combo box. It works okay, but sometime I am unable to select the
specific number in the drop out list.

Ex: The drop out list has 200 items to select. When I select item 90, it
places item 80 in the box. Is there any way to fix the problem? Please help

Thanks
Chi

 

[Dirk Goldgar]

Hi,

I have a combo box. It works okay, but sometime I am unable to select the
specific number in the drop out list.

Ex: The drop out list has 200 items to select. When I select item 90, it
places item 80 in the box. Is there any way to fix the problem? Please
help

Does your combo box's rowsource include items with the same value in the
bound column? If so, Access won't be able to distinguish between these two
apparently identical values. For example, if you have a 2-column combo box
with this row source:

1; A
2; B
1; C

and the first column (the numeric one) is the bound column, then selecting
the row with "C" in the second column (1; C) will result in the combo's
current row being set to the first row (1; A), because that is the first row
in the list with 1 in the bound column.