Print report based on filtered records on form

**shod90** · 09-04-2018, 01:14 AM

Dear Gents,
I have a form that can i filter my products by qty or by name or whatever .. I need to make my report to be printed based on my search on my form ..
My search in form is done by using select statements something like - task = "SELECT * FROM Products"
Me.RecordSource = task

How can i print my report based on form RecordSource ?

**June7** · 09-04-2018, 02:03 AM

I don't see any filter criteria in that SQL. Instead of setting form RecordSource suggest you set Filter property. Use the same filter criteria for report. Review http://allenbrowne.com/ser-62.html

Print report based on filtered records on form

Thread Tools

Print report based on filtered records on form

Similar Threads

Print Report from filtered datasheet on Sub-form

Trying to print a report, but get the print of the form instead, and it's for all records

Report based on Query but filtered by form

Select Report fields based on filtered form

Report based of filtered data from a form

Posting Permissions