Setting scroll bar positions in VBA

[Simon Baker]

I have a continuous record form on which it is necessary
to requery the data source on certain user actions. When
the requery and refesh are completed, the form always
moves to the top of the window, meaning the user has to
scroll back down to the original position.

Is it possible to read and set the position of the
vertical scroll bar, or is there another way of ensuring
that the view remains the same after the requery?

Many thanks

 

[Sandra Daigle]

Hi Simon,

You can do this two ways - one is to cache the primary key of the current
record by saving it in a local variable before the requery, then after the
requery, use that value to find the record.

Another somewhat easier way is to use the GetSetSB functions by Stephen
Lebans to Get and Set the scrollbar:
http://microsoft.com/downloads/deta...6C-C5B6-44AC-9532-3DE40F69C074&displaylang=en

 

[Sandra Daigle]

Oops - try this link instead: http://www.lebans.com/setgetsb.htm