title: Access VBA: using `do while` loop to update a recordset
body: <p>I would like to get a result using a <code>do while</code> loop. 
  However, my result gives only one record...</p>
  
  <p>What I'm trying to do is:</p>
  
  <ol>
  <li>Move through <code>rs</code> (record-set) records </li>
  <li>Check if a value in <code>rs</code> is equal to <code>rs2</code></li>
  <li>If so, copy the <code>username</code> from <code>rs</code> to <code>rs2</code></li>
  <li><p>Move to the next record</p>
  
  <pre><code>Do While Not rs.BOF                                  ' No of records in rs     
      Do While Not rs2.EOF                             ' No of records in rs2          
          If Trim(rs2![pic_no]) = Trim(rs![pic]) Then            
              rs![UserID] = rs2![NEW_USER]
              rs2.MoveNext
              rs.Update   
          Else
              rs2.MoveNext
              rs.Update    
          End If
      Loop          
  
      rs.MovePrevious
      rs.Update
  Loop
  </code></pre></li>
  </ol>