Filter Datasheet Form By Multiple Fields

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
LVL 10
GozrehAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
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
 
Helen FeddemaCommented:
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
 
GozrehAuthor Commented:
Very Nice Filter

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

Can someone help me with this ?
0
All Courses

From novice to tech pro — start learning today.