Apply Filter

[houseofturner]

I have a macro which Applies a Filter to a form using the values in a combo box using the Apply Filter command.

The form itself has multiple combo boxes and each has this option.

It runs off the after update function on the combo box.

When I select a new combo box it releases the old filter and applies the new one.

However, what I really want to do is to apply then filter and then when a select a value from another combo box for it to to filter within the filter that has already been applied.

Any ideas?

 

[Minty]

I don't think you can achieve this in macros very easily. You can if you stick your toe into some VBA though.

 

[GinaWhipp]

Hmm, probably not via Macros, have a look at...
http://allenbrowne.com/ser-62.html