Multi Based Criteria for SubReport

[lostfan789]

I have a report setup that prints a single record. I get to this report by having the record open through a form and a command button to print preview the report. I have various subforms (data only applying to that record) that are also outputted on the report and that's working fine.



But now my issue is that I have subreport that has three separate criteria I need to specify. The three controls are BrandName (value), Type (text) and DropNo (value). I have a separate table called OfficeCopies. In this are various people that, depending on the brand, type and drop, are assigned various quantities of the product. I want the report to show this list of people for the particular record only. BrandName and Type are listed on the main form and DropNo is listed in a subform.

Right now, I have a query set up to show all the fields I need, but when I add the subreport to my main report and run it, no data is showing up and I'm getting prompted to enter the three controls. Let me know your questions. Thanks.

[llkhoutx]

Put the variables in controls on the form calling the report and populate them, then filter the subreport record source with those form control values.