REQUERY WITHOUT SCROLL SCREEN.

[Guest]

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.

 

[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.

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

 

[Arvi Laanemets]

Hi

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

 

[Guest]

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