I have a Main form with a subform(datasheet view)
When dbl-clicking on any field of the subform, I open another form (frm_2) with all the details of the record clicked in the subform.
Private Sub contact_name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frm_2", , , "ID = " & Me.ID
End Sub...