I'm pretty sure you just need to Requery the ListBox.
>Does any one know how to clear out a multiselect listbox? I found one on
>Allen Brown's website, however, I couldn't get it to work. What I am trying
>to do is clear out the select items once the query/report is generated.
>Thanks!

Signature
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
Stacey - 12 Mar 2007 20:31 GMT
I found the solution under a response by Ofer. Thanks for the response.
For i = 0 To ListBoxName.ListCount - 1
ListBoxName.Selected(i) = false
Next i
> I'm pretty sure you just need to Requery the ListBox.
>
> >Does any one know how to clear out a multiselect listbox? I found one on
> >Allen Brown's website, however, I couldn't get it to work. What I am trying
> >to do is clear out the select items once the query/report is generated.
> >Thanks!