title: Access: Move to next record until EOF
body: <p>I need to loop through a form by moving to the next record in the recordset.</p>
  
  <p>I am using the Form_Current event to loop thru.
  I have used a couple of statements and have different outcomes.</p>
  
  <p>This one sometimes crashes and gives the error message: "You can't go to the specified record."  </p>
  
  <pre><code>DoCmd.GoToRecord , , acNext
  </code></pre>
  
  <p>This one only goes upto 72 records and stops.  </p>
  
  <pre><code>DoCmd.RunCommand acCmdRecordsGoToNext
  </code></pre>
  
  <p>This one only goes upto 129 records and stops.  </p>
  
  <pre><code>Me.Recordset.MoveNext
  </code></pre>
  
  <p>Trying to find an instruction that will go to the next record untill it reaches the End of File.
  I am using Access 2010 (Access 2002 -2003 file format mdb) as the front end. The recordsource is a SQL Server 2008 linked View.</p>