The value selected in a combo box is not what shows up

[kmsperry]

I have an unbound combo box that I populate using the following query:
SELECT Customers.PartnerID, Customers.CustName FROM Customers WHERE (((Customers.PartnerID)=[Forms]![Partners-Detail]![Master_ID])) ORDER BY Customers.CustName;

I get the correct values displayed when I hit the drop down arrow. The problem I have is that when I choose any of the values the one that actually shows up as selected is always the first item in the list.

Any thoughts at what I'm doing wrong?

KMS

 

[pbaldy]

It would appear you're not using a unique key value. You restrict the list to a given PartnerID, so every selection in the list will have the same PartnerID.

 

[kmsperry]

Paul,

You were exactly right. I made the change and it worked as intended.

Thank you for your insight.

KMS

 

[pbaldy]

Happy to help!