Cannot show multiple values for combobox DisplayMember?

[Rashar]

Hello, I'm trying to populate my ID and Dealername in my combobox, but when I try the below scripts, I'm only seeing the ID at runtime... How can I show both the ID and DealerName in my combobox? Me.cboSelectDealer.DataSource = ReportDS.Tables("tblCall_Reports") Me.cboSelectDealer.DisplayMember = "UID" & "-" & " DealerName" Me.cboSelectDealer.ValueMember = "UID" Me.cboSelectDealer.DataSource = ReportDS.Tables("tblCall_Reports") Me.cboSelectDealer.DisplayMember = "UID" + "-" + " DealerName" Me.cboSelectDealer.ValueMember = "UID" Thanks in advance.

[Coding123456]

I realise this is an old post but it might help someone else out. I needed to do a similar thing but I didn't want to concatinate fields in the sql used to fill the datatable as it was contained in an existing stored procedure. So I filled the datatable with the records I wanted then basically added another column in the datatable which was my concatinated display value. I then used this new column as the DisplayMember. assuming we have a datatable which is populated with "AccountCode" and corresponding "AccountName" eg "ABC" , "Freds workshop" "XYZ" , "Bills Lighting"

'Add a new calculated column to the datatable
Dim DataCol As DataColumn = New DataColumn("Display")
DataCol.DataType = System.Type.GetType("System.String")
DataCol.Expression = "AccountCode + (' - ') + AccountName"
dt.Columns.Add(DataCol)

'Now setup the combobox
cmbAvailableCompanies.DataSource = dt
cmbAvailableCompanies.DisplayMember = "Display"
cmbAvailableCompanies.ValueMember = "AccountsCode"

It will now display "ABC - Freds Workshop" and "XYZ - Bills Lighting" in the combobox. The only issue I have found is if I turn sorting of the combobox on the SelectedValue of the combobox gets out of sync with the Displayed value. I haven't worked this out yet but for the time being I can live with it.