Filter Selection -- backup a level?

Posted on 2006-06-07
Last Modified: 2012-08-13
I have form showing severl columns of a table -- It allows the user to place the cursor in a field and "Filter by Selection".

The way that I understand the "Filter by Selection" selection option - is that the user can then go to another column, select a value an again choose "Filter by Selection" to continue to obtain a subset of the data.

When the choose the "Remove Filter Sort" option -- it returns all records.  Is there a way to back up to the prior "Filter by Selection"?

Example:  Table fields include: Issue Number, Description, Status, Reported by, Priority, Closed Date.
User selects 'Closed' status and "Filter by Selection"
User selects 'High' priority and "Filter by Selection"
User selects 'Closed Date' status and "Filter by Selection"

Is there an easy way to back up to the filter prior to the last one?  Or do I need to store the each filter and refresh the list?


Question by:aeolianje
    LVL 74

    Accepted Solution


    To answer your question: No, there is no way to "Back Up" (revert) to the previous filter.

    However, try using "Filter by Form" instead.
    This will make it much easier for users to apply/remove filters.
    It also lets you "see" the filter criteria.

    Instead of clicking the Filter by Selection icon, click the Filter by form Icon. (Should be the next icon to the right of the Filter by Selection icon)

    Then you can Select *all* the fields to filter at the same time or indivdually.
    This is achieved by using drop-down boxes.

    To view the filtered result, click the "Apply Filter" button.

    So If you filter:
    State= "NY"
    City= "Brooklyn"

    You could easily remove the "Brooklyn" value from the City drop-down box to return to the previous filter.

    To clear all criteria, Click the "clear grid" icon (It looks like an "X") on the toolbar.
    Or Click: Edit-->Clear Grid.

    Hope this helps

    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Thanks for the grade!

    BTW: for further reading on "Dynamic Filtering" see this Site/Link:

    Glad I could help!

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Suggested Solutions

    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now