I have a form set up to search my table and it opens another form or report (based on a checkbox) with the filtered results. The filter is a combination of a query and a where condition on DoCmd.OpenForm/DoCmd.OpenReport. If the search terms are too specific and there are no records that match, I want a message box to pop up and inform the user instead of just opening a blank form or report. I can't figure out how to do it. Please help!!