Putting records filtered on a form into a report.

C

Craig

I have some forms were the users are able to use a filter-by-selection,sort
either by AZ-ZA. The users then want to see the results in the report exactly
as they are on the form after the filtering and sorting is done. Any idea on
how to accomplish this?

TIA
-Craig
 
M

Matt_W

The form filter can be passed to the Report as in the following code...

DoCmd.OpenReport "Report1", acViewNormal, , Form_Form1.Filter

Regards,

Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a RecordsetClone for a Report Recordsource? 2
Filter a Report with a Form 2
Open a form to a specific record without a filter 3
How can I filter by Dates on a Form? 6
Filter in Form Help 0
On Double Click - Filter Transactions to New WorkSheet 0
Printer friendly report based on a filtered form 5
Recordset as Criteria for Form Filter 2

Top