title: How to keep from going to first record when requerying?
body: <p>Making a form in Access 2010.  I'm trying to make a button that moves to the next record (or the first if it's at the end), but because I want to account for other users' updates to the data set that have occurred in the meantime, I'm requerying the form before going to the next record.</p>
  
  <p>I'm using the following code, adapted from <a href="https://stackoverflow.com/questions/2426371/in-an-access-form-how-to-return-to-previous-record-after-requery">this SO post</a>:</p>
  
  <pre><code>Private Sub NextRec_Click()
  
  Dim currentID As Long
  
  currentID = Me.id.Value
  
  
  'Here is where the requery brings the form back to the first record
  Me.Requery
  
  
  With Me.RecordsetClone
      .FindFirst "id=" &amp; currentID
      If Not .NoMatch Then
         If Me.Dirty Then
            Me.Dirty = False
         End If
         Me.Bookmark = .Bookmark
      End If
  End With
  
  If Me.CurrentRecord &lt; Me.Recordset.RecordCount Then
      DoCmd.GoToRecord , , acNext
  Else
      DoCmd.GoToRecord , , acFirst
  End If
  
  
  End Sub
  </code></pre>
  
  <p>It's working fine, except that <code>.requery</code> causes the form to briefly return to the first record before going back to the current record and then on to the next record.  I don't want it to do this--is there any way I can just keep the current record showing in the form while <code>.requery</code> takes place, instead of showing the first record for the split second while <code>.FindFirst</code> is looking for the record at <code>CurrentID</code>?</p>