title: Create only non-duplicate records using SQL queries in Access-VBA
body: <p>Issue detail: I have spent nearly two full days and I am still unable to find solution to this issue:</p>
  
  <p>Step 1: I have a table named “table1”. It has three fields which are already populated. I created them using an insert SQL query from within VBA:</p>
  
  <pre><code>For n = 1 To .cbo_sbstRep Step 1 
      strsql = "INSERT INTO table1 (A, B, C ) " _
      &amp; "Values (" &amp; .cbo1 &amp; "," &amp; .cbo2 &amp; "," &amp; n &amp; ")"  
  
      CurrentDb.Execute strsql, dbFailOnError
   Next n
  </code></pre>
  
  <p>This creates values in field C: 1, 2, 3</p>
  
  <p>Step 2: Next, I am keeping the values of .cbo1 (corresponding field_A) and .cbo2 (corresponding field_B) same and just changing the input variable for field_C in table 1 using a combobox. Here, I changed it to 5.</p>
  
  <p>I want the insert query to run again but do not insert record for values of 1, 2, &amp; 3 as they already exist and instead just create values 4 and 5. The target table should have values in field C: 1,2,3,4,5 at the end. </p>