Use criteria from Report for Subreport

[HaChIrish]

I have a report and subreport based on respective queries. Both queries have criteria asking for [policy number]. How would I code it so that the subreport will automatically use the same policy number the main report is using?

Thanks in advance

 

[MattS]

You could remove the criteria from the query that feeds the subreport. Then in the design view of the report, use policy number to link the child/master fields on the subreport.

Or, use a control on a form as the source of the policy number, and refer both queries to the control.

HTH.

Matt.

 

[HaChIrish]

MattS, you are the man! Never even thought to look for that option. Thanks a million!