Selecting result on query subform

[jcpelejo]

Hello. I was wondering if there is any way of selecting a record from a query subform results and placing the information after double clicking on the result onto another form. Please advise.

 

[AlexBeet]

I have a query subform called [Project subform] which is displayed in form view on a form called [Project].
The following code is located in the double click event of one of the controls on the subform and opens another form called [ProjectView]. The criteria sent to open form [ProjectView] is [Property_id] which is taken from which ever record is double clicked on the subform.


Private Sub Cntrl1_DblClick(Cancel As Integer)
DoCmd.OpenForm "ProjectView", acNormal, "", "[Property_id]=[Forms]![Project]![Project subform].[Form]![Property_ID]", acEdit, acNormal
End Sub


I hope this makes some sort of sense and is of some help

 

[jcpelejo]

Thank you. That worked fine.