Hi everyone,
I made a button in VBA code to open a different form which takes a value from the subform and then displays it in the new form opened.

Down below is the code used:

Function Personnels_Select()
On Error GoTo Personnels_Select_Err

    With CodeContextObject
        DoCmd.OpenForm "RAI", acNormal, "", "[DOSSIER_RAI]=" & "'" & .Personnels_DossiersRAI.Form!DOSSIER_RAI & "'", , acNormal
    End With

Personnels_Select_Exit:
    Exit Function

Personnels_Select_Err:
    MsgBox Error$
    Resume Personnels_Select_Exit

End Function

Private Sub BtnSuivi_Selection_Click()
    Personnels_Select
End Sub

I also want to achieve the same result but without using the Button.

I want to be able to double click the field [DOSSIER_RAI] found on the subform so it opens a different form called "RAI" based on that particular field. So criteria is [DOSSIER_RAI]

I tried copying the button vba code but it's not working..
Any help would be appreciated!

Pjay