title: Access "No Current Record" error 3021 on form load from SQL data
body: <p>I have a split form which, when only 1 record is present in the underlying query, will exhibit the following behavior:</p>
  
  <ul>
  <li>Populate with all data from the 1 record</li>
  <li>Give the No Current Record error whenever attempting to manipulate <code>Me.Recordset</code> (even though the data is displayed)</li>
  </ul>
  
  <p>This error continues to happen if I either:</p>
  
  <ul>
  <li>Refresh the form (using F5 or mForm.Refresh)</li>
  <li>Requery with mForm.Requery</li>
  </ul>
  
  <p>However, if I have 2 records returned by the underlying query, switching between the records in the splitform datasheet causes this problem to go away. </p>
  
  <p>I am at a loss for what I can do to stop this from happening with:</p>
  
  <ul>
  <li>Access 2010</li>
  <li>ODBC linked connection </li>
  <li>SQL server 2008</li>
  </ul>
  
  <p>Is there a way I can trigger something in the <code>form_load</code> event to do whatever switching records causes to happen?</p>