Apply two filters

[fathyano]

Hello

Here is my question:

1. First open the form called "Interface"

2. There is two groups of buttons, each one opens the same form ("table1", which base on the table "table 1") but applies different query.

3. When pressing the button "Alexandria", I opens the for and filters the results to show only records which the field "City" is Alexandria.

4. Keep the form opened.

5. When we deal with the second group of buttons "Occupation", and press- for instance- "Lawyer", while the form is (still open) and filtered with "Alexandria", what will happens is as follow:

"The previous filter "Alexandria" will be CANCELLED, and ONLY the new filter "Lawyer" applies.

What I want to do is:

WHEN I PRESS THE BUTTON "Lawyer" after pressing the button "Alexandria", I want:

The second filter "Lawyer" is applied, BUT, on the previous filter (i.e.: - Apply a new filter, but keep the previous), so the result will be that:

The form opens and show me the records of people living in "Alexandria" ((AND)) working as Lawyers.

Hope my question is clear,
Thanks in advance

 

[llkhoutx]

Use an option group to designate your combinations of criteria, then with one button build the appropriate criteria based upon the option group value.

Alternatively, change, modify or adjust the filter property of the form with your successive criteria as appropriate. Leave the FilterOn property set to Yes when you have a filter.

 

[fathyano]

Thank you, but I am so sorry to say that I do not understand what u r saying, am not so professional, so plz can u simplify ur answer? and I will appreciate if u did it on my attached sample database.

 

[fathyano]

Why I have been Ignored guys???