?
Solved

Filter Selection -- backup a level?

Posted on 2006-06-07
3
Medium Priority
?
234 Views
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?

Thanks,
Jeanne

0
Comment
Question by:aeolianje
  • 2
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 17021553
aeolianje,

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:
Country="USA"
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

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 17026906
aeolianje,

Thanks for the grade!
:)

BTW: for further reading on "Dynamic Filtering" see this Site/Link:
http://www.fontstuff.com/access/acctut19.htm

Glad I could help!
;)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 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