Subform events do not seem to be firing

[mantooth29]

So I have learned that a parent form does not inherently know or respond to any subforms events, excluding OnEnter and OnExit.



But if I have code in the subform specific to its events, say DblClick on a datasheet subform with a message box "Hi!", should it not fire even if the double click occurs when the parent form is loaded.

I have been able to code and see the event when working directly on the subform (ie, not loaded via parent form), but when it is loaded in the parent form double clicking in the control elicits no response.

Am I missing something?

'In Subform Code Module.  This works if only the subform is loaded.
Private Sub Form_DblClick(Cancel As Integer)

    MsgBox "This was a dbl click"

End Sub

[John_G]

Hi -

From what I can see, your code is in the event for the Form double-click, not in the double-click event of the control. Try putting the code in the dbl-click event of the control on the subform. I use this technique in a number of applications, and it works fine.

HTH

John

[mantooth29]

Thank you for the response John. I see what you mean about the Detail_DblClick although I was able to get this working via the form double click. But, I had to recreate the form from scratch to get there. This subform went through several redesigns (with a few name changes) and I'm guessing I hosed one of the event properties in a wizard somewhere.