double click(or any) event within subform?

[shy216]

i have a subform which lists of data.
is it possible to create an event from that list?
like if user double click a "name" from a subform?
each row contains different info so... how would i approach this>?

 

[PHV]

Each control has a DblClick event, so where is the problem ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shy216]

Private Sub subReservation_DblClick(Cancel As Integer)
On Error GoTo Err_subReservation_DblClick

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "subReservation"
stLinkCriteria = "[Name] = '" & Me![Name] & "'
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_subReservation_DblClick:
Exit Sub

Err_subReservation_DblClick:
MsgBox Err.Description
Resume Exit_subReservation_DblClick

End Sub

so should this work?

 

[PHV]

[Name] = '" & Me![Name] & "'[highlight]"[/highlight]

You want to open a form already used as subform ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[shy216]

oops i meant to open another form

 

[PHV]

I'd use the DblClick event procedure of the [Name] control.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886