list box problem

[Sport]

I have a form and on this form I have 2 combo boxs (a,b) and one list box
(c). Combo b is populated based on what is selected in combo box a, and
then the list box is populated based on the selection made in combo box b.
Now I have it set so that on the change event of combo box a, it requries
the list for combo box b; which clears it. Now here is the problem, I also
want to have the list box clear in this same event. Currently it keeps the
entry from the previous data selection, but does change accordingly when a
new selection is made in combo box b. I can not seem make this list box end
up blank again, I can do it if I change it to a combo box, but I need to use
a list box. Any idea's and if I have confused anybody please let me know
and I will try to simplify things.

Thank you.

 

[Dirk Goldgar]

I have a form and on this form I have 2 combo boxs (a,b) and one list
box (c). Combo b is populated based on what is selected in combo box
a, and then the list box is populated based on the selection made in
combo box b. Now I have it set so that on the change event of combo
box a, it requries the list for combo box b; which clears it. Now
here is the problem, I also want to have the list box clear in this
same event. Currently it keeps the entry from the previous data
selection, but does change accordingly when a new selection is made
in combo box b. I can not seem make this list box end up blank
again, I can do it if I change it to a combo box, but I need to use a
list box. Any idea's and if I have confused anybody please let me
know and I will try to simplify things.

Thank you.

Probably you need to set the value of combo b to Null, as well as
requerying it.