title: Access 2010 subform requery not working but did in 2003?
body: <p>I am trying to figure out why a subform Requery is NOT showing changed records (or new or deleted for that matter) in Access 2010/2007, when it worked in 2003?</p>
  
  <p>If I close/reopen the form, that values are correct but not until then?
  Has something changed in 2007/2010 that requires an additional step?</p>
  
  <p>This is a subform used by multiple forms - and I am NOT trying to refresh/requrey based on anything happening on the main form, etc.
  There is a button on the SUBform that makes this call to move a record UP (re order the rows);</p>
  
  <p>The database is SQL Server 2005, not local access if that makes any difference.</p>
  
  <pre><code>Private Sub btnUp_Click()
  On Error GoTo Error_Handler
  Dim blnUpdateSwitch As Boolean
      blnUpdateSwitch = False
  Dim blnRemoval As Boolean
      blnRemoval = False
  
  ' Commit any outstanding edits before moving the records.
  
  Me.Refresh
  
  Dim intCurrentRecord As Integer
  intCurrentRecord = Me.CurrentRecord
  If Me.Recordset!blnSwitch = True Then blnUpdateSwitch = True
  If intCurrentRecord &gt;= 2 Then
      Me.Recordset.Edit
      Me.Recordset!lngSequence = intCurrentRecord - 1
      Me.Recordset.Update
  
      Me.Recordset.MovePrevious
  
      Me.Recordset.Edit
      Me.Recordset!lngSequence = intCurrentRecord
      Me.Recordset.Update
  
      Me.Recordset.Requery
      If blnUpdateSwitch Then CalculateSwitchOrder
  
      Me.Recordset.AbsolutePosition = intCurrentRecord - 2
  
      Me.Requery
  
  End If
  
  Exit Sub
  
  Error_Handler:
  
  End Sub
  </code></pre>