Print report based on the search subfrom results

Lennon

New member
Local time
Today, 18:11
Joined
Feb 24, 2012
Messages
8
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!
 

Users who are viewing this thread

Back
Top Bottom