ListBox.Requery

[Don]

I have a form with 3 ListBoxes. Clicking on the first ListBox will populate
the second ListBox. Clicking on the 2nd ListBox will populate the third on.

Here is my isse. When I click on the 1st ListBox a second time (I've
already clicked on the second ListBox after I clicked on the 1st ListBox the
first time) I want the 3rd ListBox to unpopulate. I think that even the 2nd
ListBox has requeried, it is still got the selection highlighted from the
first time I clicked it but I don't know how to solve this problem. I've
tried the following code, but it doesn't work.

Me.lstCATEGORY.Requery '-This is the 2nd ListBox'
Me.lstITEMS.Requery '-This is the 3rd ListBox'

The 2nd ListBox recalculates but the 3rd one does not. Some help would be
appreciated. I am using Access 2000.

 

[Arvin Meyer [MVP]]

Clicking on a selection in the first list box should requery the
secondlistbox, and clear the third listbox. To clear the selection in a
listbox, use:

Me.ListboxName = ""