L
LennyD
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.
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.