Multiple filter with unbound text boxes

[cbende2]

Hello all,



The layout: I have form1 listed in continuous view. I have about 10 fields being listed. I have unbound text boxes for each field in the form header designated as a filter for each field.

Ideal world: Have each filter update records as you type. But I would also like for a "cascade" effect on the filters as well. Being that I can type in a few letters in FilterField1, and type in a few letters in FilterField2 and it would only display the records where the criteria is met for both filters.

Anyone has any references on this?

What I'm not looking for: Only applying 1 filter at a time for 1 field. I have this setup now, but would like it to be more versatile allowing several fields to be filtered at once.

Any help is great, thanks!

[ItsMe]

This tutorial describes one way. When using multiple inputs, you will need to build a string that concatenates the values as WHERE criteria. This is not described in the video.
https://www.youtube.com/watch?v=N0X8Hg-Sm6A

[cbende2]

Thank you, I also found another helpful link:

http://bytes.com/topic/access/insigh...form-filtering

Problem solved!