title: check for duplicates before saving record in Access 2010
body: <p>In saving data from a Form, I want to check for duplicate email and password. If email and password is already in table, prompt with some message. I also tried with many control event but the events were not fired; nothing happened. Maybe my code is wrong, so please help and guide me how to check for duplicate email and password.</p>
  
  <p>Thanks.</p>