Open Record using Sub Form

[Juan Schwartz]

I've seen this done... where one can double click a subform and open
an edit form with the record double clicked in the previous subform.
Can I get a link to a tutorial or sample of this?

 

[Guest]

Pretty simple, really. You use the Double Click event of one of the controls
in the subform form. Here is an example:

Private Sub txtPropertyName_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmProperty", , , "[PropertyID] = " & Me.txtPropertyID

End Sub