[AccessD] FW: Basic Question

How do you put a set the BeforeUpdate to a function...I thought you could 
either pick [Event Procedure] or the name of a macro?

Thanks,

Mark


>From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: [AccessD] FW: Basic Question
>Date: Thu, 22 Feb 2007 10:02:01 -0800
>
>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.
>
>
>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Find what you need at prices you’ll love. Compare products and save at MSN® 
Shopping. 
http://shopping.msn.com/default/shp/?ptnrid=37,ptnrdata=24102&tcode=T001MSN20A0701