Filter Continuous Form

[mike60smart]

Hi Everyone



I have the following records in a Continuous Form

Tutor	Class	Homework
Bob Jenkins	1R	Biology
Bob Jenkins	1R	Biology
Bob Jenkins	1R	Biology
Bob Jenkins	1R	Biology
Bob Jenkins	1R	Maths
Bob Jenkins	1R	Maths
Bob Jenkins	1R	Maths
Bob Jenkins	1R	Maths
Bob Jenkins	1R	Maths
Bob Jenkins	1R	English
Bob Jenkins	1R	English
Bob Jenkins	1R	English
Bob Jenkins	1R	English
Alan Woods	2R	Geography
Alan Woods	2R	Geography
Alan Woods	2R	Geography
Alan Woods	2R	Geography
Alan Woods	2R	Geography
Alan Woods	2R	French
Alan Woods	2R	French
Alan Woods	2R	French
Alan Woods	2R	French
Alan Woods	2R	French
Alan Woods	2R	French
Alan Woods	2R	French

Is it possible to create a Search Box in the Header of the Form that would allow me to filter to display
only the records for Alan Woods and French?

Any help appreciated.

[Micron]

Yes, although I think I'd use a multi-select listbox to facilitate getting the criteria input to be proper. So looping over the selected items and building a sql string.

[Bob Fitz]

It should be.

I would have a combo box for each of the required criteria and some code in each combos After Update event to set the appropriate filter setting and apply/remove the filter. If you post a copy of the db we may be able to help further.

[xps35]

Something like this? It's very basic; I guess you have tutor and homework tables.
Sorry for the Dutch

[mike60smart]

Hi Peter

That works just great.

Many thanks

[xps35]

Or try 2.0