I have a report that contains a subreport that lists a breakdown of summary information for one of the grouping levels in the main report. I open the main report with user defined criteria (from a form), with the "where string" developed in VBA code based on which (if any) fields the user specified criteria for. Works great for the main report, but I can't figure out a way to get the subreport to use the same criteria. I tried, in various places, putting the filter criteria used on the main report in the subreport, but Access (97) won't let me do that. Because anywhere from none to four fields may have criteria, it wouldn't be practical to have a separate version of the subreport based on which combination of fields have user specified criteria. By the way, the criteria that the user may select are different from the linking fields between the main and subreports. Anyone have a suggestion?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Enable varied criteria for subreport
- Thread starter BSman
- Start date
Similar threads
- Locked
- Question
