ok Code:
  1. Private Sub DisplayList(ByVal CusRef As Integer)
  2.         Dim ConnectionString As String
  3.         Dim SQLString As String
  4.         Dim TitleString As String
  5.         Dim conn As System.Data.OleDb.OleDbConnection
  6.         Dim dr As System.Data.OleDb.OleDbDataReader
  7.         Dim cmd As System.Data.OleDb.OleDbCommand
  8.         ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;data "
  9.         ConnectionString += "Source=" & "Opticians.accdb "
  10.         conn = New System.Data.OleDb.OleDbConnection(ConnectionString)
  11.         SQLString = "SELECT * FROM SpecSalesTable" 'SELECTS ALL INFORMATION
  12.         Try                                     '    FROM DATABASE
  13.             conn.Open()
  14.             If ConnectionState.Open Then
  15.                 cmd = New System.Data.OleDb.OleDbCommand(SQLString, conn)
  16.                 dr = cmd.ExecuteReader()
  17.                 If dr.HasRows Then
  18.                     FramesListBox.Items.Clear()
  19.                     While dr.Read
  20.                         If Not IsDBNull(dr.Item("CustomerID")) Then  'INSERTS INFORMATION INTO
  21.                             TitleString = dr.Item("CustomerID")      '       LISTBOX
  22.                             FramesListBox.Items.Add(TitleString)
  23.                         End If
  24.                        
  25.                     End While
  26.                 End If
  27.                 dr.Close()
  28.             End If
  29.         Catch
  30.             MessageBox.Show("Error accessing database")     'IF ERROR ENCOUNTERED SHOWS MESSAGE
  31.         End Try
  32.         conn.Close()
  33.     End Sub


So that works, but how do I display multiple things, CustomerID & CustomerName on the same line?

I can't get it going, it only puts my CustomerName under the ID