title: Do While Loop not giving me correct output string
body: <p>I'm trying to assign a list of Names to a combobox control in Access VBA.</p>
  
  <p>My problem is that the output string of names is not correct.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Private Sub command186_click()
      Dim firstName As String
      Dim lastName As String
      Dim rst As Object
      Dim rowSourceText As String
      Dim fullName As String
  
      Set rst = CurrentDb.OpenRecordset("Pool_Contact")
  
      Do While Not rst.EOF
          firstName = rst("FName").Value
          lastName = rst("LName").Value
          fullName = firstName + " " + lastName
          rst.MoveNext
      Loop
  
      Forms(FrmDaysAvailable).Controls("Combo202").rowSource = fullName
      Debug.Print fullName
  End Sub
  </code></pre>
  
  <p>I know that the error is somewhere inside of my loop, where the variable fullName is written over by the second result.</p>
  
  <p>how can I fix this loop to produce a string that looks like fullName , fullName, fullName ...</p>
  
  <p>Thanks for all your help</p>