REQUERY WITHOUT SCROLL SCREEN.

L

LLUIS

I have a form with a subform that have a timer to requery each 10 seconds.
The problem is every time that do the requery, the screen go to the first
record and this is a very important problem with the operator. Anyone know
how I have to do for requery within scrolling screen?

Thanks.
 
C

chriske911

I have a form with a subform that have a timer to requery each 10 seconds.
The problem is every time that do the requery, the screen go to the first
record and this is a very important problem with the operator. Anyone know
how I have to do for requery within scrolling screen?

Thanks.
Click to expand...

create a global variable
== Option Compare database
== dim RecHolder as string
store the current record in that variable using the record pointer or
some other unique field inside your record
== private sub control_click()
== RecHolder = [recordID]
== me.requery
after the requery you can use something like this
== Set rs = Me.Recordset.Clone
== rs.FindFirst "[recordID] = " & RecHolder
== If Not rs.EOF Then Me.Bookmark = rs.Bookmark
== end sub

grtz
 
A

Arvi Laanemets

Hi

Something like this?
......
Dim rs As Recordset
Set rs = Me.RecordsetClone
Me.Requery
Me.Bookmark = rs.Bookmark
......
 
L

LLUIS

The options that you say don't run right. Do you know another solutions? I
want to get the last records in the suform like a "REQUERY", but the
scrollbar don´t go to the first record. This action ACCESS, because in Visual
Basic is going on.

Thanks
 
Top