I need a query display all records when none are found

[RobertEastham]

I have a keyword search database. When I enter a word that's not found, I end up looking at a blank form. I want it to instead show all records or return an error message stating no records found.

Thank you!

 

[Joe4]

How is the search done? Are you doing it via a parameter query?

If so, this topic has come up numerous times before and you should be able to find solutions using the Search functionality on this board.