need to empty the contents of a list box

  • Thread starter Thread starter Richard Hollenbeck
  • Start date Start date
R

Richard Hollenbeck

I have four list boxes that fill in different data, one after the other,
depending on the selection of the previous one. If somebody changes the
choice of the first list box, for example, the second list box will change
but the third and fourth will not be affected. I tried various ways to
clear the data from the other boxes but to no effect.

A web page I read said to do this:

lstListName.RowSource = ""

That doesn't do anything in Access 2002. Maybe it worked in previous
versions. Maybe I have to create a dummy RecordSet with no records and
reference that. Is there another way to clear the contents of a list box?

Thanks,
Rich Hollenbeck
 
Back
Top