title: What causes a "The search key was not found in any record" error in Access 2010?
body: <p>The error message "The search key was not found in any record" was appearing on one record of a table in Access 2010.</p>
  
  <p>I first noticed this when accessing that record via an update query, but later found that I also got the same error when trying to delete the record. </p>
  
  <p>What causes this, and how can it be resolved?</p>