[AccessD] BeforeUpdate v. AfterUpdate

IIRC Oldvalue only works at all on bound controls.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: 20 May 2003 19:59
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] BeforeUpdate v. AfterUpdate
> 
> 
> 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/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>