title: MS Access rookie - Ask for confirmation before updating a record
body: <p>I'm trying to create a small MS Access database to ease up my everyday job. The problem is I'm a noob when it comes to databases. <strong>I'm trying to prevent the user from accidentaly updating the wrong record.</strong></p>
  <ul>
  <li><p>I have a table of records, some of which are not 100% complete.</p>
  </li>
  <li><p>I created a query that lists only these incomplete records.</p>
  </li>
  <li><p>On a form, the mentioned query is fed into a listbox.</p>
  </li>
  <li><p>I want the user to be able to pick an incomplete record from this listbox and fill in some of the remaining parts of the record in a bunch of text boxes. What I don't like is that <strong>the record gets updated</strong> as you fill in the form fields (they're bound to the table) <strong>WITHOUT any request for confirmation</strong>. If the user picks a wrong record at the start, the records are gonna get messy with every text box filled. Or that's what seems to be happening.</p>
  </li>
  </ul>
  <p>Here's my idea of the user form:</p>
  <p><a href="https://i.stack.imgur.com/nOasS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nOasS.png" alt="my idea of the user form" /></a></p>
  <p>Is there a correct way to do this? <strong>I could force it all with VBA</strong> but I'd rather avoid that and use a more native (correct) solution.</p>
  <p>Thank you for any answers.</p>