Clear Listbox after Running Report

[Khatru]

I have three list boxes on a form: TermList, SegmentList and YearlyList. These list boxes can either be runindividually or altogether. I want toclear the bar that highlights the option in each list after a report is run,otherwise I have to close the form an reopen it.


I have tried creatinga button in which the statement on “On Click” would state: TermList.RowSource = “” I have also tried TermList.RowSource =Null. Each Time I try the button I get amessage that states “The object TermList is not found”. I have also tried putting in the list box “AfterUpdate” option: Me.TermList = Null. Thisdid nothing. Any thoughts on what I ammissing. Thanks.

[amrut]

Sample code to clear the list box bar that highlights the selected item -

     Dim i As Integer
10    For i = 0 To Me.lstItems.ListCount - 1
20    Me.lstItems.Selected(i) = False
30    Next i

The error indicates that the control name TermList is incorrect.

[Khatru]

Thanks. That worked. I just did not get the result I was hoping for. When I run just one list box, say listsegment, it only gives me results when segment 1 is selected. When I try any other segment I do not get any results. I will post in a new forum.