title: How do I switch between Access Form and Datasheet views, and remain on the same record, without filtering?
body: <p>In MS Access 2007, I want to switch between datasheet and form views, without filtering, and remain on the current record.</p>
  
  <p>Should I use a bookmark ? How ? or How might I place a button on the ribbon to switch views, without having to search for the record or use a filter.</p>
  
  <p>I need this to run Access 2007 Runtime, since it will be implemented on a non-licensed computer. Seems some of the ribbon butttons &amp; groups are not showing even if defined:</p>
  
  <p>I tried the "GroupViews" and "ViewsModeMenu" options in the ribbon but they do not work in the Runtime. Also, any ribbon options that change the view also requery to the first record in the dataset, instead of retaining the current record.</p>