Requery on continuous subform

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

Bill Sturdevant

I have a subform that is displayed as continuous records.
If I am down looking at the 15th record and I do a
requery, I end up looking at the first record. How can I
do the requery and remain on the 15th record?
 
Unfortunately, when you do a requery, all bookmarks are invalid.

So, you have to bite the bullet and grab the absolute position, or grab the
current id.


Dim lngPos As Long

lngPos = Me.ID
Me.Requery
Me.RecordsetClone.FindFirst "id = " & lngPos
Me.Bookmark = Me.RecordsetClone.Bookmark
 
Back
Top