Here's a fun one...ToolTips, ListBoxes, DataSets..Oh MY! [RESOLVED,THIS BOARD ROCKS!]

[milkmood]

One ListBox (customer) contains data from a database, another ListBox (part number) gets filled when an item in the customer ListBox is clicked (SelectedIndexChanged).

What I want to do, is display a ToolTip containing the Part Description (another field in the partdefinition table, which is already in the dataset) when hovering over the partnumber in the second ListBox.

Here's the event that puts the part numbers in the second ListBox based on the selected customer from the first:

Private Sub lbxRecCust_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles lbxRecCust.SelectedIndexChanged
 
        'Dim srch As String
        Dim sqlsrch As String
        Dim dssrch As New DataSet
        Dim dasrch As New Odbc.OdbcDataAdapter
 
        Try
            sqlsrch = "SELECT * FROM partdefinition WHERE LOWER(customername) LIKE '%" & CType(lbxRecCust.SelectedItem, DataRowView).Item("customername").ToString.ToLower & "%' ORDER BY partnumber ASC;"
            dasrch = New Odbc.OdbcDataAdapter(sqlsrch, con)
            dasrch.Fill(dssrch, "partdefinition")
        Catch ox As Odbc.OdbcException
            MsgBox(ox.Message)
            Exit Sub
        End Try
 
        With lbxRecPart
            .DataSource = dssrch.Tables("partdefinition")
            .DisplayMember = "partnumber"
        End With
 
        'MessageBox.Show("There are no parts associated with this customer", "No Parts", MessageBoxButtons.OK)
 
    End Sub