Report from current records on form

[Spiet]

How do I create a report that displays the current records "behind" that form. An example: If somebody use the filter function and there are 25 records filtered, I want to have a button on a form that creates a report with the 25 records displayed.

PLEASE HELP ME OUT! THANKS!

 

[RichO]

Set up a report based on the same record source as your form, then in the On Open event of your report you can copy the filter property from your form:

Me.Filter = [Forms]![MyForm].Filter
Me.FilterOn = True