Return Msg On No Data

[EliteDesk@aol.com]

I have a form based on a query, I want to display a msgbox informing user when there is no data and canceling the open form action. I was hoping for an easy fix like NoData event for reports. What is the easiest way to do this? Thanks you for your time.

 

[Rich]

using the search facility's a good place to start
http://www.access-programmers.co.uk/forums/showthread.php?t=62548&highlight=recordsetclone

 

[EliteDesk@aol.com]

thanks

Thank you! It was a perfect fix.