G
Guest
I am trying to change the recordsource of a subreport when the main report
opens. I have entered:
strSQL = "SELECT * FROM Jail_Record_Offense WHERE Release_Date is null"
Me.rsubOffenses.Report.RecordSource = strSQL
'rsubOffenses' is the name of the sub Report and it's underlying report name.
I get the error:
Run-time error '2455'
You entered an expression that has an invalid reference to the property
Form/Report.
What is wrong with my reference?
opens. I have entered:
strSQL = "SELECT * FROM Jail_Record_Offense WHERE Release_Date is null"
Me.rsubOffenses.Report.RecordSource = strSQL
'rsubOffenses' is the name of the sub Report and it's underlying report name.
I get the error:
Run-time error '2455'
You entered an expression that has an invalid reference to the property
Form/Report.
What is wrong with my reference?