Returned No Results Message Box

[Swilliams987]

Hello!



I have a parameter query that, when run, asks the user for the county's name and the year they are interested in looking for data, qryLRCACountyYear. This query is used as a filter for frmLRCACountyYear.

This works beautifully when there are results to show. But if there aren't any results, then it opens frmLRCACountyYear as a blank form. When no results are found, how can I get a message box to say "no results found" and then opening frmMainMenu after pressing "ok"?

[ajetrumpet]

I'm not sure, but right away i can think of something like this on the load event of the form:

if me.recordsetclone.recordcount = 0 then
   msgbox "no records found!"
      docmd.close acform, me.name
      docmd.openform "frmMainMenu"
end if

[Swilliams987]

That's the code that I've been using...or very similar to it. I tried what you posted and no luck, but then....I realized that I had other similar code in two other places on two other events. Once I deleted that code everything worked! YAY! Thanks again!