Newbie on report/subreport

[Chris]

Newbie question, still have not found what I need from
books etc.

I have a form that is essentially the results of 1 form
and 2+ other child forms. The first part of the report is
based off a query where I pass in the where clause. Now
the second/third part of form is based off the first part
(and essentially 2 other queries) that would use the same
where clause. So, my question is, how do I attach the
same where clause on to the last 2 pieces of the report.

Thankx:

Chris
(e-mail address removed)

 

[Duane Hookom]

Where is the "Where" coming from? Are you using text boxes on forms as
criteria in your report record sources?

 

[Chris]

Duane:

Yes, they have it set up so the where is actually one
value from a textbox on the screen, and depending on how
many times they hit the "next record" button....

I can get the "where" passed into the first of the 3 parts
of the form (into the query) but I do not know how
to "code" the where into the next 2 subreport and there
corresponding queries....

Chris

 

[Duane Hookom]

Can't you use a criteria in the "next 2 subreport" record source queries
that uses the value typed into the "textbox on the screen"?