Print report based on the search subfrom results

[Lennon]

Hy to all!

I have a db of blood donors. I have a search form in witch I have a subform for results. When I click on search button it filters results and show them in subform.

Now I need a code or something to show these results in report. I had something like:


DoCmd.OpenReport "report", acViewPreview, , qry.ID=me.subform.form.ID

but then it show me only the first record.

I can't use the where statement also because i have a search criteria for date with INNER JOIN statement.

PLEASE HELP!

 

[Lennon]

Anyone have some idea????