Solved

Filter Datasheet Form By Multiple Fields

Posted on 2013-06-06
3
565 Views
Last Modified: 2014-02-12
I have a datasheet form and I wish to filter by multiple fields.
If I click on one field arrow I can choose field values for filter.
If I click on second filed I do not see field values and can define Text Filter (write a value for filtering).

How can I define my form to allow multiple field filtering with ability to select values in each filed by clicking on the field name ?

Thank you for your help
0
Comment
Question by:Gozreh
3 Comments
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 39226694
See my Fancy Filters sample database:

http://www.helenfeddema.com/Files/accarch129.zip


Here is a screen shot of the form:
Fancy Filters form
0
 
LVL 10

Author Comment

by:Gozreh
ID: 39226898
Very Nice Filter

but you don't have the option to filter one field with multi select

Can someone help me with this ?
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39228177
If you right-click one column, you can apply a filter for this.
If you right-click another column, you can apply a filter for this. The first filter remains.
When a column is filtered, a sign is shown at the right in the header.

/gustav
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

816 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

8 Experts available now in Live!

Get 1:1 Help Now