It's actually a Main form with 2 nested subforms. Selecting the datasheet record subform3 selects the corresponding record in the Form of subform2. After clicking on the datasheet to select the record, the focus automatically goes to the first record. I can click on the same datasheet record to regain the focus. I've been searching, but this activity is not very common. I just want to click on the datasheet record and have it stay focused on that record. The code I have used for the on_click of subform3 is:
Code:
Private Sub Form_Click()
Dim rs As Object
Set rs = Forms!frmSPK.frmSPKSF.Form.Recordset.Clone
rs.FindFirst "ID=" & Me.ID
Forms!frmSPK.frmSPKSF.Form.Bookmark = rs.Bookmark
End Sub