I have two macros for two unbound text boxes on a form.

Each macro applies various filters depending on what is entered in its
particular text box - the macros are set to run "on exit" from the text box.

Say I enter "EM" in text box 1, this will filter for all schools in the East
Midlands

BUT if I then enter "Primary" in the other text box (i.e. looking for
primary schools in the East Midlands) it brings up every primary school in
the country.

Is there a "filter only the records currently on display" command I can put
in my macros to solve this problem?

Any help much appreciated