MSA 2k cascading filtered unbound list boxes

  • Thread starter Thread starter Ken Chappell
  • Start date Start date
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?
 
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?

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top