Re: Combo box filtering

Thanks Allen,
I downloaded the sample. All my data type is Text.
The user has limited choice in each of the combo boxes to pick from.
It is for a School. In the first combo box, the values are Math,
Reading , or Math and reading.
The second combo box value is the classroom they are assigned to, which
is limited. Junoir, Middle and Higher.
The third combo box, the most important one, is the status of each
student. They are current, Vacation, Discontinued.
I looked at your sample and that is exactly what i wanted, but with no
date filters or number filters.
If you need more info of my table structure, let me know.
Thanks for your time
Allen Browne wrote:
So you want to place 3 unbound combo boxes in the Form Header, and a command
button to apply the filter based on whatever combination of values the user
entered?

You will need to use VBA code to create the string to use for the Filter of
the form. The actual details will depend on the data type of these fields.

If you can use VBA, and would like an exmaple to follow, download:
http://allenbrowne.com/unlinked/Search2000.zip
The small sample database shows how to build the Filter string from the
boxes that have values, and how to use the delimters for the different data
types. Requires Access 2000 or later.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"charleedongo" <charleedongo@xxxxxxxxxxx> wrote in message
news:1149015121.793434.183700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello Everyone,
Iam facing a problem when i try to filter a continuous form with
multiple combo boxes.
here is the situation. The form is based on a query. The query has
fields,
Last name
First Name
Subject
Status
Classroom

Subjects offered are Math and reading. Status is current, vacation,
discontinued.
Classroom is Junoir, Middle, Higher.
I would like to create such a filter where iam able to see all the math
students alone or reading students alone. These are dependent on the
status field. For example, i would like to see all math students who
are current in the Junior class room. I understand that this requires
three combo boxes which are interconnected.
Pls help me with the code by which i can achieve this.

.