Charlotte Foust
cfoust at infostatsystems.com
Tue Aug 7 13:14:51 CDT 2007
AfterUpdate doesn't have a cancel argument, but you could raise a messagebox from the AfterUpdate event of the control. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Tuesday, August 07, 2007 11:07 AM To: accessd at databaseadvisors.com Subject: [AccessD] No Duplicates After Update is the correct place to put this right? *********** Should be: If DCount("ContainerNo", "tbl_Containers", "ContainerNo = '" & [ContainerNo] & "'") -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com