Hey all,

I am using a TDBComboBox to display data (linked to a database) on a userform. I have a field called 'Cust#' and one called 'CustName' in the box. The bound column is set for CustName (which needs to be displayed in the box after user selection) but there can be multiple Cust# values for each CustName.

i.e. Cust# CustName
123 Company A
4567 Company A
999 Company A
222 Company B
... and so on...

My question is, for a given customer name, how can I allow the user to select any of the associated cust #'s with it? Regardless of which row I select, the bookmark always chooses the very first instance of that customer name (like if I choose the row with Cust# 4567/Company A, the bookmark returned to me is that of Cust# 123/Company A).

Any help would be greatly appreciated...