Help with Subform.

[Guest]

Hello,
On my main form I have a subform that I would like to refresh or requery
every 10sec.

When I add the expression for the me.refresh in the subforms timer event.
All the forms refresh and cause the afterupdate events to go off if a record
is open.

I then tried the me.requery and bookmarked the current postion. This causes
the subform to jump around.

So is their a way to refresh or requery with out the subforms postion moving
or jumping or anything like that.

Thank you in an advanced.
David Ehrenreich

 

[Al Camp]

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

Steve Leban's SelTop code will allow requery of a subform with no "jumping"

Works very well...
hth
Al Camp