I have a query where I use a simple "Like [Enter Number]" to open a form. What is the best way to approach when no record is returned? I just want to put a message box saying there is no record matching that criteria...then cancel. I've tried OnOpen and OnLoad, but thats not working. Any help would be greatful.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Best way to identify no record when opening a form
- Thread starter GoinDeep
- Start date
- Status
Similar threads
