Using Bookmarks

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

I have a form, who's record source is a parameter query.
Currently, when I requery the form, the form displays the
first record. If I am on the 3rd record of the form, I
would like the form to display the 3rd record after the
requery takes place. How can I accomplish this in Access
2000 VBA? Thanks.
 
Hi,
Something like this:

Dim varBookmark as Variant

varBookmark = Me.Bookmark
'do your requery
Me.Bookmark = varBookmark

HTH
Dan Artuso, MVP
 
Back
Top