title: Access 2010 - Check data in recordset before adding new record
body: <p>I'm new to Access so bear with me here.</p>
  
  <p>I have a form that allows me to add new data to a table</p>
  
  <pre><code>ID  | Name |  City  | Zip Code
  1   | John | Newark | 12340
  2   | Alex | Boston | 98760
  </code></pre>
  
  <p>So on and so forth...</p>
  
  <p>Before proceeding to add a new record with the above data fields, I need to create a check that will look at the table to determine if the combinations of Name, City and Zip Code already exist.  If they do, I want it to Exit Sub; Else continue with the rest of the macro.</p>
  
  <p>I've been looking to build this using some form of the OpenRecordset command, but I'm not sure where to begin.  Can someone point me in the right direction?  Thanks!</p>