I'm using a form with an unbound listbox to let users filter down a report. The only field on the form is the listbox. If the user doesn't select anything from the list box but clicks the command to open the report, I want nothing to happen. I tried achieving that with this line of code:
Not working though. The report still opens with every record. Any idea what I'm doing wrong? Let me know if the full code is needed or an example DB.Code:If Me.listComplaintCategory.ListCount = 0 Then Exit Sub