>Is there a way to display the results of an array in a listbox if the query selects 0 records. I basically want to show a blank listbox if no records meet the criteria and show all records if any match. The problem is, if the 1st query returned 2 records and the 2nd query returned 0 records the 2 records from the 1st query remain in the listbox instead of blanking it out. Any help would be appreciated.
If the second query returns 0 records then just do:
lstMyListBox.Clear()
Rip Ryness
International Falls, MN