return to last place after requery

[yaniv d]

hi everyone,
i build a form based on a query.
this query is returning the new values after doing requery
the problem is when you do requery the screen returns to the first
record.
is there a way to make the screen stay in the same place that have been
updated?

 

[Arvin Meyer [MVP]]

Yes, try something like:

Dim lngID as Long 'ID before requery.

'Get the ID, unless it is a new record.
If not Me.NewRecord Then
lngID = Me.txtID
End If

'Requery, and find the ID again.
Me.Requery
With Me.RecordsetClone
.FindFirst "ID = " & lngID
If Not .NoMatch Then
Me.Bookmark = .Bookmark
End If
End With
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[yaniv d]

thanks for your help arvin,
my question is if im using information for filtering,will it be usefull
for finding the row or i need diffrent sentence for it(i have several
of groups depending on)


Arvin Meyer [MVP] כתב:

 

[yaniv d]

thanks alot Arvin your answer helped me
yaniv d כתב: