Update Combo Box

  • Thread starter Thread starter Leo
  • Start date Start date
L

Leo

Hi -

I have 3 combo boxes that reads 3 separate fields from one
table.

I am trying to figure out how to 'filter' the other 2
combo boxes to show only data relevant to what was
selected in the 1st box.

Please advise.
Thanks
 
Hi Ken -

Thanks.
However, I have 6 combo boxes in total and I want to be
able to pull all fields when any 1 combo box is left blank.

I know a Is NULL statement might work. But when I put more
than one 'Is NULL' statement in the 'OR' row of my design
query, my combo boxes go blank.

Please advise.

Thanks!
 
Excuse me for my confusion, but your original post said nothing about using
the combo boxes as query criteria? Can you provide more details about what
you're doing so that I can be sure I'm on track with you?
 
Hi Ken -

Ok. Here goes.

I have 6 combo boxes that read 6 different fields from 1
table (e.g. Region, Country, Department etc).
I am trying to 'filter' all other combo boxes whenever an
item is selected from any 1 (or 2 or 3 or 4) combo box. So
for instance, if 'Asia Pacific' Region is selected, I want
to see all countries and departments etc. in that region.
And if ONLY department and country is selected, I want to
see the region associated to that and so on. As you can
see there is an enormous number of possibilities since we
have 6 combo boxes.

So far, here is how I have it configured. For EACH COMBO
BOX I have:
- A 'AfterUpdate' code that runs 'Requery' on all the
other combo boxes (i.e. on the other 5 combo boxes)
whenever an item is picked from the drop-down menu
- Under 'Row Source' I have an SQL statement that Selects
a list of items based on fields (NULL or not) in the other
5 combo boxes.

This configuration is fine when I am just using 2 combo
boxes. But when I do the same thing for 3, my combo boxes
become blank unless an item is selected (NOT NULL) in the
other 2 combo boxes.

Have I confused you already?

Thanks!
 
Back
Top