How to link my subreports

[CSAngel]

I need some help figuring out how to properly link my subreports.
I have the following:

A table containing a list of issues and risks. The table contains a field
indicating if the record is an issue or a risk (type). I also have a date
indicating when the record was last updated (status date).

What I want is a report with two subreports - one with open issues, one with
open risks. However, I also want to be able specify a date so that I only
get issues/risks that have been updated before the specified date.

What I did:

I have a form with a text box to enter a date and a button to generate the
main report.

I have a main report that gets all the records before the specified date
(not visible).

Now I want the two subreports to list the issues updated before the date,
and the risks before the date.

I'm not sure where to put each of the conditions.

Any help would be appreciated.

Thanks!

 

[Duane Hookom]

I don't understand why the main report would have any record source. The
subreport(s) would simply have a reference to the text box value in their SQL
like:

SELECT *
FROM tblIssuesRisks
WHERE [StatusDate]<=Forms!frmNoName!txtNoName

You could use a single report with no subreports and just group by the
[Type] field.