Pass Value from Report To Query

[brc]

I have a Saved query that is pulling data from tables and other Saved Queries. I have a SQL statement built in VBA which pulls from that Main Saved Query and then I set as a reports record source. In VBA I specify criteria one being That a parameter (which is a date), from a form, is between 2 Dates.

Problem I am having is that one of the Saved queries that is in the Main Saved Query also needs to use that (Date) as criteria also. But I don't know how to get this date to the saved query that is in the Main Query.

I hope that makes sense.

Brc

[brc]

If this needs more clarification please let me know.

Thanks