scroll bar position in continuous forms

[Guest]

I've got a continuous form in a subform control that gets updated every 10
seconds. The trouble is that no matter where the user puts the scroll bar, it
returns to the top with each refresh of the data. If a record is selected, I
can reset the form to that record and that keeps the window in a fixed
position. But if the user doesn't select a record, is there a way to make the
same record appear at the top of the window on each refresh?
Any ideas?
Thanks.
Jay

 

[Guest]

Bookmark the record, do the refresh, then go back to the bookmark.
Bruce

 

[Guest]

Bruce,
Thanks for getting back to me.
The solution you suggested works only if the user has picked a record to
make the bookmark something other than the first record (or "before" the
first record). I'm just talking about the user employing the scroll bar to
position the records so that the fifth record (as an example) is showing at
the top of the window. If the user actually selects that record, I can
reposition, but if the user doesn't select the record, on refresh the window
is repositioned so that the first row is again at the top of the window. I
would like to "bookmark" the first record showing in the window and restore
that record to the same position on refresh ... but I don't know how to get
at that information in Access.
Jay

 

[Dirk Goldgar]

I've got a continuous form in a subform control that gets updated
every 10 seconds. The trouble is that no matter where the user puts
the scroll bar, it returns to the top with each refresh of the data.
If a record is selected, I can reset the form to that record and that
keeps the window in a fixed position. But if the user doesn't select
a record, is there a way to make the same record appear at the top of
the window on each refresh?

As usual, when it comes to user-interface wizardry, Stephen Lebans has
the answer:

http://www.lebans.com/setgetsb.htm

SetGetSB.zip is a database containing functions to allow
a user to Set or Get the current position of a ScrollBar Thumb
for a Form.

 

[Guest]

Dirk,
Thanks! That sounds like just what I need. I'll try it.
Jay

 

[Guest]

Dirk,
Thats it! It works like a champ! I really appreciate the help from you and
from Stephen Lebans.
Jay