title: MS Access VBA to set scrollbar position of a subform that is a continuous form
body: <p>I have a form with a subform.  The subform is a continuous form so I can use conditional formatting.  Using controls in a Tab Control, the values of the currently selected record on the subform are changed.  So, I requery the subform to update the subform continuous form to show the updated data.</p>
  
  <p>I can get the correct record re-selected in the subform, but the position of that record in the list jumps to the top of the subform's list instead of maintaining the position it was in prior to the update.</p>
  
  <p>I have tried playing with the CurrentSectionTop values of the subform, but I am not able to correctly maintain the user's selection position within the subform after requerying the subform.</p>
  
  <p><strong>Is there some way to get the current position of the subform's continuous form's scrollbar position and then set that position in code after the continuous form is requeried?</strong>  (Stephen Lebans' code for doing this (see: <a href="http://www.lebans.com/SelectRow.htm" rel="nofollow">http://www.lebans.com/SelectRow.htm</a>) does not work for me because I'm using Access 2013 and his code won't convert to Access 2013).</p>
  
  <p>Here's a sample of what the subform continuous form display might look like to begin with while Record 7 is the current record selected:<br>
      {start of continuous form view}<br>
      [ ] Record 3 in continuous form view<br>
      [ ] Record 4 in continuous form view<br>
      [ ] Record 5 in continuous form view<br>
      [ ] Record 6 in continuous form view<br>
      [>] Record 7 in continuous form view<br>
      [ ] Record 8 in continuous form view<br>
      [ ] Record 9 in continuous form view<br>
      {end of continuous form view}<br>
      {tab control displays down here below the continuous form subform}  </p>
  
  <p>After the subform is requeried, here is what the subform continuous form display looks like, but I want the display to look the same as above; the display should <em>not</em> put Record 7 as the top record in the continuous form view since it was the 5th record down in the view originally so I want it to be the 5th record down after the requery:<br>
      {start of continuous form view}<br>
      [>] Record 7 in continuous form view<br>
      [ ] Record 8 in continuous form view<br>
      [ ] Record 9 in continuous form view<br>
      [ ] Record 10 in continuous form view<br>
      [ ] Record 11 in continuous form view<br>
      [ ] Record 12 in continuous form view<br>
      [ ] Record 13 in continuous form view<br>
      {end of continuous form view}<br>
      {tab control displays down here below the continuous form subform}  </p>