Subform Click Event

[Dudley]

I'm trying to code an event that would occur when a user double-clicks on the Record Selector of a subform. I want it to then open a form that would provide additional details about the record selected in the subform. I can't find documentation to tell me (1) where to put the code, i.e. subform double-click event vs. subform detail double-click event, etc.; (2) how to reference the record id of the selected record for use in the filter for the form that is going to be opened (the underlying query contains the ID for the record). Can anyone help or point me to documentation? Thanks!!!
(The file is in 2000 format)

 

[Crispy]

Hi - try something like this in the On Dbl Click event of your subform:

Private Sub Form_DblClick(Cancel As Integer)
Dim StrForm As String, strCriteria As String
If IsNull(Me!YourRecordID) Then
Dim msg, style, title, response
msg = ("No details exist for this record")
style = vbOKOnly + vbExclamation
title = "Error"
response = MsgBox(msg, style, title)
Else
StrForm = "YourNewForm"
strCriteria = "[YourRecordID]=" & Me![YourRecordID]
DoCmd.OpenForm StrForm, , , strCriteria
End If
End Sub

 

[Dudley]

Thanks Crispy! You confirmed that I was on the right track and I've got it working with your help. Thank you!!!!
-D