Re: Combo box filtering
- From: "charleedongo" <charleedongo@xxxxxxxxxxx>
- Date: 4 Jun 2006 09:50:58 -0700
Thank You allen.
Your code worked. I have one more favor to ask you. One of the combo
boxes has values "Current", "vacation""Discontinued". I would like my
form to open to show only the current students. So when i open the
continuous form, it should give me a filtered result of the current
students only.
Please help.
Allen Browne wrote:
Okay. You can ignore the examples for numbers, and dates, and just use the
code that has all those quotes for each of your cases.
--
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:1149091406.619476.305650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.
"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.
.
- Follow-Ups:
- Re: Combo box filtering
- From: Allen Browne
- Re: Combo box filtering
- Prev by Date: Re: How do I change who the laptop is registered to? In Systems file.
- Next by Date: RE: append problem
- Previous by thread: Re: How do I change who the laptop is registered to? In Systems file.
- Next by thread: Re: Combo box filtering
- Index(es):
Relevant Pages
|
