title: Access- Vb- updating one table based on other table's value
body: <p>I am using Access DB with vb. 
  I want to update the values of one table base on other tables values</p>
  
  <p>for example
  Table A has columns a1, a2, a3,.....
  Table B has columns b1,b2,b3.......</p>
  
  <p>if a1 and b1 are he ID numbers, for each matching ID in table B, the value of B3 has to be updated in a3 as well</p>
  
  <p>If first value of b1 is 1234, then search for 1234 in tableA , the update tha a3 position of that particular row with b3 value.</p>
  
  <p>Please let me know how to move on with this.</p>