Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    12

    Report Filter Problem

    I have created many reoprts using the report wizard, and afterwards I used the filter feature to filter my reports. However, when I close the report and open it back up, the filter is not on and I have to press toggle filter to return the filter back to how I set it. I am making this database for clients that I know will have a problem with that, Is there any way I can set it up so that the filter remains on when the Report is closed? Thank you in advance!

  2. #2
    trb5016 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Pennsylvania
    Posts
    71
    Try setting the Reports FilterOnLoad property to "Yes"

    I think this uses the last filter and applies it when the report opens

  3. #3
    Join Date
    Jun 2010
    Posts
    12
    Thanks, but where can I find that selection "FilterOnLoad" I tried to find in the properties of report, but can't find it. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Advanced Report Filter
    By bigdan5428 in forum Reports
    Replies: 1
    Last Post: 05-08-2010, 08:17 PM
  2. filter by form for report
    By stephenaa5 in forum Reports
    Replies: 1
    Last Post: 05-08-2010, 03:14 AM
  3. Form Filter Causing slight problem
    By cowboy in forum Forms
    Replies: 3
    Last Post: 04-15-2010, 07:32 AM
  4. How to Filter Report
    By mikel in forum Reports
    Replies: 2
    Last Post: 08-28-2009, 10:11 AM
  5. Replies: 19
    Last Post: 05-12-2009, 02:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums