Subform selection to open record

[wrightyrx7]

Hi All,

I have a subform that displays all records from a table.

I also have a form that displays a single record from the table.

What i want is when someone double click the record on the subform all the details of that record open in the form that displays a single record.

What is the best way to do this?

Thanks in advance
Chris

 

[jdraw]

What have you tried? What result?
Have you tried opening a form from the double click event?

 

[Ranman256]

You don't need to dbl-click anything.
The master form shows a record ,and the sub form shows a record that belongs to it automatically.

In the master form header put a box to enter ID,or name search
In the AFTERUPDATE event of the box, filter the record.
Sub txtFind_afterupdate()
Me.filter= [clientID]=" & txtBox
Me.filterOn= true
End sum

 

[arnelgp]

Private Sub Text0_DblClick(Cancel As Integer)
DoCmd.OpenForm FormName:="yourFormName", WhereCondition:="[pkKey] = " & Me.[pkKey]
End Sub

 

[Uncle Gizmo]

You may find this Useful:-

http://www.baldyweb.com/wherecondition.htm