Query input used in subquery

[melaniecarr23]

Say I have a report named plans, based on a query named plans_query.

This query has a plan_id of 7, which I'm prompted to enter.

Can I make subqueries to be used in the plans report (in sub-reports) and make the plan_id of the subqueries equal to the plan_id of the main query?

My issue - I don't want someone to have to enter the plan id over and over again for each of the subqueries referenced in the report.

I haven't gotten that far yet, and figured if I would ask before I got there.

Thanks,
Melanie

 

[melaniecarr23]

Okay I figured it out and now remember how a subform links fields with the master form - I've got it!

To be helpful to anyone else who might ask this question:

If you have several subqueries and reports and would like them all to pull information based on one item, put the fields for user input in the main query for the main form. Then link the fields when inserting the subreports and you're good to go!

I hope this helps at least one other person, cause you all have been so helpful to me.

Thanks.