1 Replies - 771 Views - Last Post: 23 May 2017 - 06:26 AM

#1 jjsaw5  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 92
  • View blog
  • Posts: 3,063
  • Joined: 04-January 08

Apply Filter By Form to Report

Posted 16 May 2017 - 08:02 AM

In Access 2013 is it possible to Apply the built in Sort and Filters to reports.

I have a few users who are using the Filter by Form option to filter a form based on Vendors. What they would like to see is when they open the report for this form for the Filter by Form to be applied to the report as well.

Is there away to carry over the Filter by Form to the report using some kind of onload event on the report?
Is This A Good Question/Topic? 0
  • +

Replies To: Apply Filter By Form to Report

#2 jjsaw5  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 92
  • View blog
  • Posts: 3,063
  • Joined: 04-January 08

Re: Apply Filter By Form to Report

Posted 23 May 2017 - 06:26 AM

solution was to add a button to launch the report and apply the filter to the report here is the code i used to complete this...

Private Sub Launch_Report()
     Call DoCmd.OpenReport(ReportName:="REPORT_NAME" _
                        , View:=acViewReport _
                        , WhereCondition:=Me.Filter)
End Sub

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1