Selection for multi-column drop down list

[evelynls]

I have a combo box for Parent_Sid that shows the Parent_Sid for a specific customer and also allows users to make changes using the drop-down list.

When the user clicks on the down arrow, it show Customer_Name (Primary Key) and in the next column Customer_Sid. The user will look for the customer name and then click on it so that the Customer_sid will be displayed and updated to Parent_Sid.

However, when the user selects one, it only shows the Customer_Name in the combo box display. Is it possible to make it show only Customer_sid in the display?

Thank you,
Evelyn

 

[evelynls]

I just found the solution. I put this in for the After Update event of the combo-box:

Me.cboParentSid.Value = Me.cboParentSid.Column(1)