Unanswered: filter on subreport with docmd.openreport
Usually I would be using something like this to open a report code-wise
The filter string however is restricted to the main report.
filter = "ID = " & Str(box_teater.Value)
DoCmd.OpenReport "md_rpt_lilleret_faktura", acViewPreview, , filter
How can I increase the scope of the filter to the subreport?
I only want the reports on ID=X, with subreports only covering ID's Y.
Would I have to make the above openreport, and after that do a direct reference on filter and requery?
Thanks in advance,
IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....