use a message box OR..
set (in code) the rowsource of the list box to "Value List" and set "No records to show" as a value in your row source.
When you do a search again you'll need to reset the rowsource to your original query.
thanks for the inputs...couldn't get those suggestions to do what I needed.
1) even if the label is visible, it won't appear on TOP of the listbox.
2) I couldn't set the first row to "No Records" because the listbox was a 10 column list box, so I needed the message to display across all of the columns..
The only way I ended up making it work, was to create a label, with a white background and a sunken special effect that was the same size as the Listbox (basically so it would look identical to the listbox) and then if there were no results, just hide the listbox, and display the label, otherwise, show the listbox....
I was hoping there would be a more "elegant" solution, but I guess sometimes you gotta do whatever it takes..
I see what you are saying....change the rowsourcetype with each iteration of the query...but then I get into other problems, because I have an onclick event on the listbox that grabs more details of that particular record, so I would have to create another check to see if the value of the listbox was "No Results"...anyway, problem is worked around now anyway....thank you.
for future reference... The check can be done in code if needed. And its not really a problem. only use it when your query returns .eof. otherwise use the normal rowsource. The code for the check can probably be completed in 1 inline if then else statement even.