ACCESS FEED: Re: [MS_AccessPros] What's the best way to filter a sub form?

Senin, 01 Juni 2015

Re: [MS_AccessPros] What's the best way to filter a sub form?

John,

Hmmmm indeed. That's what happened when I tried this.

I get errors when I try setting the Filter subreport properties from the outer report as well as when I try that in Open events on the sub reports.

For now, I created a separate outer report, with separate subreports, with a separate recordsource for the subreports. I was trying to avoid that. This works as long as it's just one, but becomes cumbersome if they start asking for a lot of others.

Adam

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Adam-

Just a guess, but add a Link Master / Link Child filter in the subreports on ProjectType. It'll probably work when the outer report is filtered, but may screw up your report on all records because the subreports will be filtered on the Project Type of the last record. Hmmmm.

Not sure that you can set the Filter and FilterOn properties of the subreports in the Open event of the outer report. You could also try testing Me.Filter in the report Open event, and if it's not empty, then replicate it in the subreports.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jun 1, 2015, at 6:40 PM, runuphillracing@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have a project tracking database. A report lists all reports for a specified time frame. That time frame criteries is in the source query: WHERE ((([tbl_Project Tracking].[START DATE]) Between [Forms]![frmNonITReports].[DateBeg] And [Forms]![frmNonITReports].[DateEnd]))

There are two summary subreports at the end - one showing count by project type, the other by project person. They use the same source query as the main report, just grouped differently and showing only the summaries.

I need to report by selected project types. That's easy on the main report - I add "[PojectType] = 8" to the Where condition of DoCmd.OpenReport if a checkbox is checked on the form requesting the report. I'm not sure how to get the summary sub reports to use the same filter. Do I use an OnLoad event for the main form, the subform, do I add the filter to the main or sub via the VBA code that opens the report?

Adam