sorry...really not good at this.
could you give me an example of this where clause?
"auditor" and "auditdate" are the common fields in both queries.
terri


"PieterLinden via AccessMonster.com" wrote:

terri wrote:
dazed and confused here....

i have two subreports that i added to a blank report.
they each run off a different query.
one gives me totals of all results of audited cases.
the other gives me the details of those cases.
the problem is, when i run the report, it asks me twice for the parameters.
both queries have the same parameters.

what am i missing?

If you're building the report off parameterized queries, you can do one of
two things:
1. remove the parameters and pass a valid WHERE clause in the OpenReport
command
2. leave the parameters in and point them to an unbound form that you use to
collect the parameter values and pass them to the open event of the report.

--
Message posted via http://www.accessmonster.com

.