title: Microsoft Access combo box overwriting first record
body: <p>I have a combo box with 4 employees in it</p>
  
  <pre><code>ID       EmployeeNumber        FirstName        LastName
  1        010101                Joshua           Dalley
  2        020202                Jessica          Daze
  3        030303                Jason            Bruyere
  4        040404                Jeremy           Bob
  </code></pre>
  
  <p>when I display the combo box, everything seems normal. I have a onChange() code which updates the firstName / lastName text box</p>
  
  <pre><code>Private Sub cboEmployeeNo_Change()
      Me.txtFirstName.Value = Me.cboEmployeeNo.Column(2)
      Me.txtLastName.Value = Me.cboEmployeeNo.Column(3)
  End Sub
  </code></pre>
  
  <p>My problem is, when I close my form frm_login, while I have selected any ID, it seems to always overwrite the first ID=1 with the last employee selected in the combo box. I do not know how to fix this. It only changes the FirstName and LastName, while EmployeeNumber stays the same.</p>
  
  <p>Example</p>
  
  <pre><code>ID       EmployeeNumber        FirstName        LastName
  1        010101                Jason            Bruyeye
  2        020202                Jessica          Daze
  3        030303                Jason            Bruyere
  4        040404                Jeremy           Bob
  </code></pre>
  
  <p>This would be my table if I close it while viewing the ID=3</p>
  
  <pre><code>Default View: Single Form
  Allow Form View: Yes
  Allow Datasheet View: No
  Allow PivotTable View: No
  Allow PivotChart View: No
  Scroll Bars: Neither
  Record Selectors: No
  Navigation Buttons: No
  Border Style: Thin
  
  Record Source: tbl_employee
  
  Allow Filters: No
  Allow Edits: Yes
  Allow Deletions: No
  Allow Additions: No
  Data Entry: No
  </code></pre>