John Colby
jcolby at colbyconsulting.com
Tue May 20 08:39:58 CDT 2003
OldValue is set to Value when the data stores, thus by AfterUpdate the OldValue data has indeed been lost. Use BeforeUpdate to store the value to a variable, then compare to that variable in AfterUpdate. John W. Colby www.colbyconsulting.com -----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:29 AM To: AccessD Subject: [AccessD] BeforeUpdate v. AfterUpdate >From my experiments, it appears that MyControl.OldValue is available for scrutiny only in the BeforeUpdate event. In the AfterUpdate event it seems to be lost. I just wanted to confirm this hypothesis. The point of the exercise is that I need to keep track of which columns a user has changed and then take action accordingly. I have to update some columns in another table depending on which columns changed in the current table, but only if the update to the current table was successul. I don't actually care about the old value, I'm just using it to determine which columns changed. But by the time I get to AfterUpdate I've lost the information. Any suggestions as to how to work around this? TIA, Arthur _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com