Dan Waters
dwaters at usinternet.com
Tue May 20 13:59:08 CDT 2003
For a control, I also use .OldValue in the AfterUpdate event and it works as expected. However, if the record is saved, the .OldValue becomes equal to the current value. This is on a bound form, perhaps that makes a difference. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Tuesday, May 20, 2003 9:44 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] BeforeUpdate v. AfterUpdate Interesting. I just did experiments and don't see how your stuff can work. In AfterUpdate, I get OldValue = Value, invariably, and I've done about 20 tests. I'm using debug.print to dump the values and in BeforeUpdate they differ but in AfterUpdate they never differ. A. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Whittinghill Sent: May 20, 2003 12:12 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] BeforeUpdate v. AfterUpdate That's interesting, because I use OldValue with AfterUpdate all the time, and it works just fine. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com