[AccessD] FW: Basic Question

Hi Rocky

Oh, that will work, I thought he was trying to achieve something else.

/gustav

>>> rockysmolin at bchacc.com 22-02-2007 19:02:01 >>>
FYI - Here's the workaround he came up with
 
Rocky
   _____  

From: Mike Dwyer [mailto:mike at aesadvantage.net] 
Sent: Thursday, February 22, 2007 9:58 AM
To: Rocky Smolin; bheygood at abestsystems.com; Dixon; Barry Hynum;
Bob_Heygood; Doug Murphy; Ed Lance; Jackie Murphy; JKA Joe K Anderson
Subject: RE: Basic Question

Thanks, Rocky.  

My workaround seems to be nice and simple:  I selected all 120 fields and in
the Property Sheet I entered: "BeforeUpdate() = True" in the ValidationRule
property.  This will call the function and if it returns False, the
validation rule will fail.  Within the function I set the ValidationText to
my error message and it works just fine.