Requery on continuous subform

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?
 
A

Albert D. Kallal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Continuous form help 8
DLookup in Continuous form 0
subform based on external SQL won't requery 1
Continuous form refresh/requery 3
changing mainform record from subform 3
Subforms 0
Requery Not Working According to Plan 10
Referring to control in the active subform 0

Top