Displaying the wrong row of data from combo box

[Rhughes53]

I have a combo box that when I select a record from it I want it to populate three other fields plus the combo box field, which it is doing fine. Except when I have duplicate fields. Such as I have a field named MFGORD which the combo box is sorted by, there are two records with the same value in it, the only difference is on the thrid field which is named MFGFAMILY there are different values on is "C01A" the other is "Tapper" I want to pick up the row with Tapper in it but it will only pull the row with "C01A" in it. I have the query behind the combo box sorted in ascending sequence by MFGFAMILY and then MFGORD, but then I have them displayed in MFGORD, Item, MFGFAMILY, Date. I've tried changing that around so they match but that doesn't seem to work either. Any Ideas what I'm doing wrong. Thanks

 

[cookiegary01]

Incorrect "Bound column" assigned?
This should be a unique value, and more often than not, an autoID

 

[Rhughes53]

Incorrect "Bound column" assigned?
This should be a unique value, and more often than not, an autoID

Thanks Cookie, I forgot about that.