How can I refresh List box highlighted entries ????

[Dylan]

I have a list box that is using the MultiSelect propery to allow selecting more than one listed Item.

I also have a button on this form that will print a report based on the items selected in the list box. I would like to code an event that would CLEAR the selected entries from the list box once the command button that prints the reports is exited. Right now it just leaves them highlighted on the form.

thanks for any assistance with this


Tom Moran
Lansing, Michigan

 

[RoyVidar]

Try reassign the rowsource:

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

Roy-Vidar

 

[Dylan]

Where would that code go ??


Tom Moran
Lansing, Michigan

 

[RoyVidar]

Wherever you'd like - button click, the end of your report code...

Roy-Vidar

 

[Eupher]

Hi, Dylan,

As always, Roy's suggestion is right on the mark, but I'll offer an alternative. I assume your code is looping through the ItemsSelected collection - must be, AFAIK that's the only way to get the values from a multi-select listbox. In the loop, you may set the Selected property of the item to False. Something like this:

For Each Entry in Me!lstMyList.ItemsSelected
    [green]'do some things here[/green]
    Me!lstMyList.Selected(Entry) = False
Next Entry

HTH,

Ken S.