Error 2455 referring to subform

[JeremyJJ]

I have been using successfully FishVal's code on http://bytes.com/topic/access/answer...vent-main-form to 'hook' subform events into VBA code on the parent form - Access 2010.

This all works fine, until changing the query to add a table that has a many-to-one relationship with the original table. If this is in place, AND the query has a condition that selects no records, then there is an error triggered in the form load event. "Run-time error '2455': You have entered an expression that has an invalid reference to the property Form/Report."

I have cut the problem down to the absolute minimum that causes the error - in the attached file.

The VBA code is:

    Private WithEvents frmSMSSubform As Access.Form
 
Private Sub Form_Load()
        Set frmSMSSubform = Me.subform.Form
End Sub
 

and the error message occurs on the SET line. Can anyone explain this?


I can find a workaround but would like to understand what is going wrong.

Thanks

main form event from subform data.zip

[NeoPa]

What's the name of your Subform control Jeremy?

Interesting question BTW ;-)

[JeremyJJ]

The name of the subform control in this cut-down example is just 'subform'. Originally it was something more descriptive, of course.

[NeoPa]

Nothing occurs I'm afraid Jeremy.

I see you have already anticipated most of what is required for posting an attachment (Attach Database (or other work)), but I was unable to look at your database as i'm not yet using 2010. If you'd like me to look at it in detail for you, you could post a 2003 version. Up to you of course :-)