View Single Post
  #1  
Old April 26th, 2010, 08:13 PM posted to microsoft.public.access.forms
KJL
external usenet poster
 
Posts: 8
Default Set focus in a specific record within a subform

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