Requery

L

laura

I need to know how to save or bookmark a record so I can go back to it when
I requery a form. My form is based on a query which I created in the Query
Design window. I have a ClientID number which I could save to a variable,
but am not too sure how to do this.

Thanks
Laura TD
 
M

Michel Walsh

Hi,


Bookmarks become without meaning after a requery. Store the primary key into
a variable and find (move to) that value after the requery.

Dim saveID as long
savedID = Me.ClientID
Me.Requery
With Me.RecordsetClone
.FindFirst "ClientID" >= savedID
Me.Bookmark = .Bookmark
End With


Hoping it may help,
Vanderghast, Access MVP
 
Top