title: multiple fields in a combobox in vb.net
body: <p>I have a form which contains a ComboBox linked to an access database. I am asking the combobox to display the Incident ID, Supplier and Supply date of all records in the database table</p>
  
  <p>The code is as follows</p>
  
  <pre><code>Private Sub frm_5_UpdateIncidentSelect_Load(sender As Object, e As EventArgs) Handles MyBase.Load
      'Links dropdown menu to incident table in database
      Dim dt As New DataTable
      Dim query As String = "select [incident ID],[stock supplier],[supply date] from incident"
      Using connection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Database.accdb")
          Using command As New OleDbCommand(query, connection)
              Using adapter As New OleDbDataAdapter(command)
                  connection.Open()
                  adapter.Fill(dt)
                  connection.Close()
              End Using
          End Using
      End Using
      Dim MyDataRow As DataRow = dt.Rows(0)
      Dim x As Integer
      x = dt.Rows.Count
      For y = 0 To x
          If y &lt; x Then
              MyDataRow = dt.Rows(y)
              ComboBox1.Items.Add(CStr(MyDataRow("Incident ID")))
              ComboBox1.Items.Add(CStr(MyDataRow("stock supplier")))
              ComboBox1.Items.Add(CStr(MyDataRow("supply date")))
          End If
      Next
  End Sub
  </code></pre>
  
  <p>The issue I am having is that the data is being returned over 3 lines as follows</p>
  
  <pre><code>12
  Supplier1
  01/01/2015
  13
  Supplier2
  07/01/2015
  </code></pre>
  
  <p>Ideally I need this information returned on one as follows</p>
  
  <pre><code>12   Supplier    1    01/01/2015
  
  13   Supplier    2    07/01/2015
  </code></pre>
  
  <p>I cannot for the life of me figure this out, I am not great with VB I am afraid. Can anyone tell me where I am going wrong?</p>