Form Error Event

Posted on 2011-10-24
Medium Priority
Last Modified: 2012-05-12
Is there a way to do a global function in an Access Form property Form Error event?

The Form - Form Error event looks like this:
     Private Sub Form_Error(DataErr As Integer, Response As Integer)

I can build code inside or call a Global Function from inside and use the DataErr (error number) and send back a Response =acDataErrContinue if certain conditions are met.

My question is there anyway to do this by just inserting a Global Function in the property sheet and pickup DataErr and be able to send back a Response - eg

Thanks in advance for any help

Question by:LJG
1 Comment
LVL 75

Accepted Solution

DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 total points
ID: 37020639
You really want this:


Seriously ... it's off the chart as I noted.

RE "=MyFormsError([DataEr],[Response])"

I've never seen a way to do that.  vbWatchdog has a different way of tapping into the error system.


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question