Filtering Question

[stewie2699]

I have a form that I display in datasheet view. The user often filters records and then wishes to print the results of the filter. I am drawing a blank: how do I get the results of the filtered query into a report? Thx.

 

[Pauldohert]

Try

In the open event of the report

Me.Filter = Form_FormName.Filter
Me.FilterOn = True

The recordsource must contain the same fields - if it is filtered in the form it must be there to filter in the report.