[AccessD] Form_Error event will NOTalways fire

Hello Bobby,
 Thanks for the reply. Yes I realize trapping errors before they
escalate to the form_error event is best. However I make use of a fairly
extensive error handler in the forms error event so I don't have to trap
common errors at each control.
 
 Works perfectly, that is when the event fires... :-)

I "Think" I found the cause of the problem, but I won't know for sure
until it happens again. (Very Intermittent)


Thanks Again!

Robert Gracie
www.servicexp.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid
Sent: Tuesday, December 06, 2005 8:01 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Form_Error event will NOTalways fire

Are you saying that you handle all errors at the form level?  Could it
be that an error is happening in code and is caught and processed so
that the form error event is not fired?

I never use the Form_Error event.  I perform validation/error handling
in code tied to the individual control itself or in a module.

Bobby 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Gracie
Sent: Monday, December 05, 2005 9:40 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Form_Error event will NOTalways fire


What would cause the Form_Error event NOT to fire.. I have been having a
problem with this, and can't get a handle on it..

Example, The user enters an invalid item in a combo (limit to list =
Yes) the user goes to move from that control and is unable to, the
problem is the Form_Error event VERY intermittently does not fire notify
the user of the problem. So the user thinks the system is locked up...

This is system wide and not just one or two forms..

SetWarning is NOT the problem...

Any Ideals

Robert Gracie
www.gbsysnow.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com