Print all data from current form filtered via "between date"

[shann]

Hello! i'm newbie in access i just want to know how to print all data based on filtered table via access builtin filter for date please see attached. I just want to print all data in my form after it was filtered by payment date , any help would do.. thanks

[CJ_London]

Not clear if you are wanting to print the filter form or use the filtered records to print another for or report.

If print the form just hit ctrl-p

if print a report with the filtered items something like this on a code behind a button

docmd.openreport "myreport",,,me.filter

[shann]

1st ill filter the form based on between date that is shown above
2nd it'll produce filtered data based on date say from 1-1-2015 to 12-31-2015
3rd i want to print those data on form to another report..

can i automatically pass that to the report i created?

[CJ_London]

yes - see last line of my first post - the report will need to have the same or more tables in its recordsource as the form and can have more fields

e.g. recordsource of form

SELECT recID, tranDate FROM tbl1

recordsource of report

SELECT * FROM tbl1 INNER JOIN Tbl2 ON .....