Drop Down list picking wrong row

[Rhughes53]

I have a drop down list in a form I've created that is based on a query, it has 11 fields in the drop down and is sorted by a customer Name, Customer number and suffix. All 11 fields are used to populate fields on the form. In the drop down there are rows with duplicate Customer Names and Customer Numbers but differrent suffixes. It doesn't seem to matter which record I select it will only find the first match of customer number and use that record to populate the other fields. I've tried changing the query to a table with the key being customer number, suffix, customer name but it did the same thing. The key in the underlaying table for the query is Customer Number, Customer Suffix. Any Idea's what I'm doing wrong? Thanks

 

[RuralGuy]

What method are you using to populate the other controls on the form? Is it VBA code in the AfterUpdate event of the ComboBox? If it is then please post that code.