title: Form bound to disconnected in-memory recordset does not refresh
body: <p>I have a continuous form and onOpen event I create dynamically an ADODB.Recordset.</p>
  
  <p>I use this values for the following properties:</p>
  
  <pre><code>Private Sub Form_Open(Cancel As Integer)
  Dim rs As New ADODB.Recordset
  ...
  With rs
      Set .ActiveConnection = Nothing
      .CursorType = adOpenKeyset
      .CursorLocation = adUseClient
      .LockType = adLockPessimistic
      .Open
  End With
  Me.Recordset = rs
  ...
  End Sub
  </code></pre>
  
  <p>Everything works fine the form opens and the recordset data are displayed correctly. </p>
  
  <p>The problem arises when a press the Refresh All button on the ribbon. Then all the records of the recordset are removed and only one remains with the #Name? value on every bound control . It must have something to do with trying to requery and being unable to do so since it is an in-memory recordset but I can not find what exactly or how I can fix it. Can someone explain me what I am doing wrong and how can I fix it?</p>
  
  <p>P.S. I use the Microsoft ActiveX Data Objects 6.0</p>