Can I pass a recordset to a report?
Posted on 2016-08-27
I have a form with a subform which contains a list of transactions filtered in various ways, by a filter which I create in code and load into the Filter property of the subform, which works.
I have a report similar to the form which I want to be able to print from a command button on the form, to contain the same data. I have tried saving the filter from the subform and loading it into the Filter property of the subreport, but Access gives a compile error. (Property doesn't support the method).
Can I pass the recordset from the subform to the Source Object of the subreport?
Thanks in advance,