Selecting Just One List Box

[Khatru]

I have three list boxes in the form “Detail InstructorForm”. Thelist boxes are: SegmentList, TermList and Yearly list. I want to be able to select differentcriteria to generate a report based on these listboxes. I would also like to select just one list boxto gather information from that criteria. (So if I want just yearly data I canselect the year that I want and generate a report that will provide informationfrom that year only). Everything works exceptwhen I try to run the report on just one list box. I do not get any data when I run the reportfrom one listbox. Below is the code I put in the query as well as the codeI put in the After Update field of the buttons for each list box.
Like [Forms]![DetailInstructorForm]![SegmentList] &"*" Or Is Null
Like [Forms]![DetailInstructorForm]![TermList] &"*" Or Is Null
Like [Forms]![DetailInstructorForm]![YearlyList] &"*" Or Is Null

Private Sub Option101_Click()


Dim i As Integer
10 For i = 0 To Me.TermList.ListCount - 1
20 Me.TermList.Selected(i) = False
30 Next i
End Sub
Private Sub Option103_Click()
Dim i As Integer
10 For i = 0 To Me.YearlyList.ListCount - 1
20 Me.YearlyList.Selected(i) = False
30 Next i
End Sub
Private Sub Option99_Click()
Dim i As Integer
10 For i = 0 To Me.SegmentList.ListCount - 1
20 Me.SegmentList.Selected(i) = False
30 Next i
End Sub
Any thoughts?

[June7]

Wasn't this solved in your other thread? https://www.accessforums.net/forms/u...xes-51346.html

Why is there a 'button' for each listbox?

Why do you need code that unselects listbox items?

Are these multi-select listboxes? Multi-select will not work with the dynamic query parameters.