title: "Not a valid bookmark" with DAO Recordset
body: <p>I'm in the process of converting an Access Data Project (ADP) into a standard ACCDB format with ODBC linked tables. In the ADP, I had overridden the Refresh button to return the user to the current record by using the following code:</p>
  
  <pre><code>Public Sub RibbonCmd_RefreshScreen(ctl As IRibbonControl, ByRef cancelDefault)
      On Error GoTo ErrHandler
  
      cancelDefault = False
  
      DoCmd.Echo False
  
      Dim saveBookmark
      With Screen.ActiveForm
          saveBookmark = .Bookmark
          .Requery
          .Bookmark = saveBookmark
      End With
  
      'Success - cancel the default behavior
      cancelDefault = True
  
  ExitHandler:
      DoCmd.Echo True
      Exit Sub
  
  ErrHandler:
      cancelDefault = False
      Resume ExitHandler
  
  End Sub
  </code></pre>
  
  <p>My understanding is that this should work just fine with DAO, but I get error 3159, <code>Not a valid bookmark.</code> I've also tried replacing <code>.Bookmark</code> with <code>.Recordset.Bookmark</code>, but that gave me the same result. Is there something I'm doing wrong here?</p>