Requery

  • Thread starter Thread starter laura
  • Start date Start date
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
 
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
 
Back
Top