Form Error Event

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
=MyFormsError([DataEr],[Response])

Thanks in advance for any help
LJG

LVL 2
LJGAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
You really want this:


http://www.everythingaccess.com/vbwatchdog.htm

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.

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.