title: Update access table with values from another table using VBA
body: <p>I have two tables, table 1 and table 2, in a database.
  I am trying to update table 1 using VBA code based on data in table 2.</p>
  
  <p>Example:</p>
  
  <p>Table 1 </p>
  
  <pre><code>PartNo  Price  Description
  --------------------------
  A      100    
  B      200      Bad
  C      300
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>PartNo  Price  Description
  --------------------------
  A        700
  B        200      Good
  D        900      Used
  </code></pre>
  
  <p>After the update, table1 should be updated with those prices or descriptions that have changed where table1 PartNo = table 2 PartNo , and add any new items that were present in table 2. </p>
  
  <p>Table 1 </p>
  
  <pre><code>PartNo  Price  Description
  --------------------------
  A      700
  B      200      Good
  C      300
  D      900      Used
  </code></pre>
  
  <p>I can't seem to get it quite right, appreciate the help.</p>