I have a form where the width of the all the columns exceeds the width of the window even when it is displayed full screen. If the user uses the horizontal scroll bar to view the columns to the right of the window and then requeries the data the scroll bar moves back so that the first column is at the left hand side of the window. The use then has to scroll back to the position where they were before the requery. Is there anyway of getting the position of the horizontal scroll bar and then after the requery resetting it back to its postion before the requery ? I have found a referent to http://www.lebans.com/setgetsb.htm
but the examples are from a very old version of Access and do not seem to work with 2007 or 2010.