Need help trapping for error

B

brian

I created a search form. If there are results another form shows witht he result set. When I search and the result set is zero then I have a message box returning saying there are no records produced. The user hits ok. Then a Access produced message box pops up saying 'The OpenForm action was canceled' Is there a way to trap for that so the user doesn't see the message.

Thanks
 
M

Marshall Barton

brian said:
I created a search form. If there are results another
form shows witht he result set. When I search and
the result set is zero then I have a message box
returning saying there are no records produced.
The user hits ok. Then a Access produced message
box pops up saying 'The OpenForm action was
canceled' Is there a way to trap for that so the user
doesn't see the message.
Click to expand...

Use error trapping in the search form to catch error 2501.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
My error trapping only works once 2
Can't hide Property Sheets 1
Disable Paste Errors dialog box 1
How to trap error 3047 4
Trap HTML Error 0
Apply error trap to all objects in worksheet? 4
Pull form in view mode from drop down menu 13

Top