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],[Re sponse])
Thanks in advance for any help
LJG
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],[Re
Thanks in advance for any help
LJG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.