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.
--
Duane Hookom
MS Access MVP
"Eiby" wrote in message
...
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...."