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.