Combo box not selecting correct field

Hi,
I have a combo box that contains this fields:
INT-03 INT-11
INT-05 INT-16
INT-06A
But when the user wants to select INT-11 the combo box displays INT-03 same
thing with INT-16 combo box displays INT-06A. The combo box it just started
doing this it was fine last week. Can anyone tell me what changed or a
setting that I might have change without noticing? Thank you.

If the combo box just started doing this, I would suspect one of two things.
1) The combo box is corrupted, delete it and create a new one. 2) The index
on the combo box's bound field is messed up (either in the Row Source table
or the destination table). Try a Compact and Repair to redo the index.

Just to clarify, you say that the combo box "contains this fields", are
these possible values in the field or are you drawing data from multiple
fields?

--
Wayne Morgan
MS Access MVP


"GYO" wrote in message
...
Hi,
I have a combo box that contains this fields:
INT-03 INT-11
INT-05 INT-16
INT-06A
But when the user wants to select INT-11 the combo box displays INT-03
same
thing with INT-16 combo box displays INT-06A. The combo box it just
started
doing this it was fine last week. Can anyone tell me what changed or a
setting that I might have change without noticing? Thank you.

Hi, GYO.

Please post the RowSource, BoundColumn, ControlSource, and ColumnWidths
properties of the combo box, and I'll be able to help you.

Sprinks

"GYO" wrote:

Hi,
I have a combo box that contains this fields:
INT-03 INT-11
INT-05 INT-16
INT-06A
But when the user wants to select INT-11 the combo box displays INT-03 same
thing with INT-16 combo box displays INT-06A. The combo box it just started
doing this it was fine last week. Can anyone tell me what changed or a
setting that I might have change without noticing? Thank you.