Multi Select List Box Clear Selections 3

[jmeadows7]

I have a list box from which I allow a user to select multiple rows. One action that the user is allowed to do once the selections are made is to delete the underlying data.

All of this works fine except that after I requery the list box, the lit box rows are still highlighted as selected and it seems as if the .ItemsSelected collection is still populated with the same number of rows.
Note: The data is deleted correctly and is not displayed after the requery.

Question:
How can I clear the selection and the ItemsSelected collection so that it does not mess up future user actions.

Thanks,

 

[RoyVidar]

Try:

[tt]me!lstList.rowsource=me!lstList.rowsource[/tt]

Roy-Vidar

 

[jmeadows7]

What SAVE!!
Thanks for the help - have a STAR!

 

[Jutrased]

Thanks RoyVidar! This solves half of my problem. The other half... Is there a way to select all items in the box with a button click?

 

[RoyVidar]

Yup, something like this, perhaps:

[tt]dim lngCounter as long
for lngCounter = 0 to me!lstList.listcount-1
me!lstList.selected(lngCounter) = true
next lngCounter[/tt]

Roy-Vidar

 

[Jutrased]

YOU DA MAN!
Just what I needed! Thank you very much! You deserve another star!