multiple filters

[angie]

i have four combo boxes in a form for filtering data. each combo refers to a
macro with just the apply filter action.

when i make a selection in a combo the data are filtered ok. but when i make
a selection in another combo my first selection is cancelled.

how can i apply multiple filters?

 

[Allen Browne]

Angie, take a look at this article:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

Download the example, and experiment.
That should empower you to do anything you need with combining multiple
filters.

 

[angie]

i have downloaded the database but i am not acqainted with writing code, i
mainly work with macros. is the code necessary to achieve multiple filters in
the form?

Ο χÏήστης "Allen Browne" έγγÏαψε:

 

[Allen Browne]

It is the simplest solution.