Prev: Form opening to new record
Next: Total in Footer
From: KJL on 26 Apr 2010 15:13
I have a main form with a subform. The subform contains multiple records and
a hidden unique id which ties it to the main form. After I enter data into a
field on the subform, I am requering the main form. I would like the focus
to remain on the subform on the specific record the user is editing. I have
been able to get the focus to remain the subform however, the focus jumps to
the first record.

Any ideas?
This is my code:

Private Sub MP_Reserve_AfterUpdate()
Forms!Liability.Form.Requery
Forms!Liability!ClmntInfoForm!.SetFocus
Forms!Liability!ClmntInfoForm!.Form![BI Reserve].SetFocus

End Sub
From: Tore on 27 Apr 2010 18:51

I guess you could use the bookmark property of your subform:

http://msdn.microsoft.com/en-us/library/aa194054(office.10).aspx

Save the bookmark of the subform when you have selected the record and use
it whenever you need to go back to this subform record. I guess you could
declare a string variable to hold the bookmark in the header section of the
subform vba code.

Dim StrBookmark as string
strBookMark = me.bookmark
me.bookmark = strbookmark

Bookmarks are destroyed in situations as described in the article.

Regards
 | 
Pages: 1
Prev: Form opening to new record
Next: Total in Footer