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.
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson