!How to pass parameters to subreports

[Guest]

Hi

 

[Guest]

Hi:

I have a main report with 8 subreports. Each subreport has a "date field". I
want to filter the records based on this "date field". What I want to do is
to aks the user "on time"to input the "date" ans pass this information to the
8 subreports.

I can use the parameters but only with each individual subreport. What I
have tried is the following:

In each subreport, on the "recordsource", on the "Datefield", "selection
criteria" I wrote "Between Date1 AND date2". The report ask for the date
parameters but only in the corresponding subreport. I don´t want the user to
input 8 times the date for each subreport.

I can not write the same critera on the main report since each subreport use
different tables.

Any idea about how to do it?

Saludos!

p.d. Thanks to Duane Hookom, Allen Browne and Marshal Barton for ther answer
to my previous question "How to do calculations...."

 

[Duane Hookom]

Always "feed" criteria to a report/query through controls on forms. You
might want to check out this site
http://www.fontstuff.com/access/acctut08.htm.