M
Murray Hopkins
Hi,
I have a form with 5 subforms (each one on a tab page). The subforms have
their Recordsets assigned as follows:
Private Sub Form_Open(Cancel As Integer)
Me.DailyAttractRM.Form.RecordSource = "Select * FROM ....etc"
End Sub
When I open the form via the Switchboard (Open form in Edit mode), I get the
runtime error 2455 - "You entered an expression that has an invalid
reference to the property Form/Report". I get the same error if I try to
access some other object on the DailyAttractRM sub form. I get the same
error if I open this form via a button click from another form and use the
DoCmd.OpenForm method.
However, if I open the form by double clicking the form directly from the
list of form objects, it works perfectly !!
The other weird thing is that it was working for a few weeks and then
suddenly started giving this error even though I didnt make any changes to
that form (or sub form) (at least as far as I can remember, anyway).
Any ideas ?
Thanks,
Murray
I have a form with 5 subforms (each one on a tab page). The subforms have
their Recordsets assigned as follows:
Private Sub Form_Open(Cancel As Integer)
Me.DailyAttractRM.Form.RecordSource = "Select * FROM ....etc"
End Sub
When I open the form via the Switchboard (Open form in Edit mode), I get the
runtime error 2455 - "You entered an expression that has an invalid
reference to the property Form/Report". I get the same error if I try to
access some other object on the DailyAttractRM sub form. I get the same
error if I open this form via a button click from another form and use the
DoCmd.OpenForm method.
However, if I open the form by double clicking the form directly from the
list of form objects, it works perfectly !!
The other weird thing is that it was working for a few weeks and then
suddenly started giving this error even though I didnt make any changes to
that form (or sub form) (at least as far as I can remember, anyway).
Any ideas ?
Thanks,
Murray