Return to same field after requery in subform

cjman

Registered User.
Local time
Yesterday, 20:46
Joined
Mar 4, 2009
Messages
28
I found this bit of code. It works to return me to the same subform field I was in prior to a requery. I am using Access 2010.

Dim strBookmark as String
strBookmark = Me.Bookmark
Me.Requery
Me.Bookmark = strBookmark
Me.Field.Setfocus

I had also tried this code if there is sequential numbering that is not skipped in the subform.
Dim Seq2 as Integer
Seq2 = Me.Seq
Me.Requery
DoCmd.GotoRecord , , , Seq2
Me.Field.Setfocus
 

Users who are viewing this thread

Back
Top Bottom