title: How to stop MS access from overwriting previous record?
body: <p>How can I stop access 2016 to stop wiping the data from previously saved records?</p>
  
  <p><strong>Any improvements/suggestions are greatly appreciated!</strong></p>
  
  <p>(<em>This is the best  I could do with my limited knowledge</em>)</p>
  
  <p>There are the following fields: Text7 ,ID, UPK, CheckTime. 
  The data to be saved back to the table is only the checktime field for each scanned item.</p>
  
  <p>Table:</p>
  
  <p>-ID  Autonumber | -UPK   Number | -CheckTime  Date/Time |-Text7 (is the only unbound control)</p>
  
  <p><strong>I need to be able to do this:</strong></p>
  
  <ol>
  <li>scan a value on Text7</li>
  <li>after the update search the table for this value (which is already) in the table see the Text7_AfterUpdate event below</li>
  <li>Text7_AfterUpdate event will populate the data into the form</li>
  <li>Automatically calculate Now() and add it to the CheckTime field (this field is empty in the table)</li>
  <li>Save the record</li>
  <li>Clear all txtboxes</li>
  <li>Set focus back on Text7</li>
  <li>Move to the last empty record and be ready to receive the next scan</li>
  </ol>
  
  <p>**EDITS thank you @Jiggles32 **</p>
  
  <p><strong>NOTE: scrapped the VBA code too cumbersome for my knowledge level, tried @Minty's suggestion and went with a query</strong></p>