MSA 2k cascading filtered unbound list boxes

K

Ken Chappell

I have some unbound list boxes on a form. They filter each other in a
cascading fashion. Some sequences are three boxes deep, a few are
sequences are four boxes deep. the problem I am having is clearing the
last few list boxes if the one firltered in front of it happends to
come up blank. If the list box gets filtered and is empty, the after
update requery doe not empty the subsequent list box. How do I do this?
 
J

John Vinson

If the list box gets filtered and is empty, the after
update requery doe not empty the subsequent list box. How do I do this?
Click to expand...

You can check the first control's RowSource query; if its Recordcount
property is 0, set the RowSource of each dependent combo to "".

John W. Vinson[MVP]
 
Top