Set the DoubleClick on the Form with the Record to:
Private Sub Form_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmThatOpensWhenRecordDoubleClicked"
stLinkCriteria = "[UniqueID]=" & Me![UniqueID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
It will open the form to the same record that you double clicked on.