View Single Post
  #2  
Old March 4th, 2010, 04:16 PM posted to microsoft.public.access.reports
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default subreport repeating parameters

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