Link to home
Start Free TrialLog in
Avatar of LJG
LJG

asked on

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

ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial