Combobox SelectedValueChanged ValueMember

[chakotha]

I have a combobox that I have filled with employees. I want to to query my database based on the selected employees ID. I have

Private Sub ComboBoxSetup()
 
    Dim strDSN As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = _
 " & Application.StartupPath & "\myDB.mdb"
 
    Dim myConnectionString As New OleDbConnection(strDSN)
 
    Dim sql As String = "SELECT EmployeeID, Surname FROM EmployeeDetails WHERE _
 CompanyID=" & CurrentCompanyID & " ORDER BY Surname"
 
    Dim myDataAdapter As New OleDbDataAdapter(sql, myConnectionString)
    Dim myDataSet As New DataSet
 
    myDataAdapter.Fill(myDataSet, "Employees")
 
    Dim myTable As DataTable
    Dim myRow As DataRow
 
    myTable = myDataSet.Tables("Employees")
 
    For Each myRow In myTable.Rows
        cmbSurname.ValueMember = myRow("EmployeeID")
        cmbSurname.DisplayMember = myRow("Surname")
        cmbSurname.Items.Add(myRow("Surname"))
    Next
 
    cmbSurname.SelectedIndex = -1
 
End Sub

In my SelectedIndexChanged event handler how do I reference the ID corresponding to the selected surname? I have tried a few things.

Public Sub cmbSurname_SelectedIndexChanged(ByVal sender As System.Object, ByVal _
 e As System.EventArgs) Handles cmbSurname.SelectedIndexChanged
 
     Dim SelectedID as Integer = cmbSurname.ValueMember
     MsgBox(SelectedID)
 
End Sub

pulls out the ID matching the last employee to be loaded into the combobox

Wood...Trees...thanks in advance