Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sat Feb 23 23:30:38 CST 2008
Joe, There's no .NewValue property that I'm aware of. So you can check to see if it has changed by "If me.txtQBInvoice.OldValue <> me.txtQBInvoice". But you need to check if it has changed in the BeforeUpdate event of the form. At that point .OldValue is still available. By the time you get to the .AfterUpdate event, the old value is gone. Another less elegant way is to save the value of txtQBInvoice in a variable in the Current event of the form. Then you can check to see if it has changed any time you want to. HTH Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Saturday, February 23, 2008 8:40 PM To: accessD at databaseadvisors.com Subject: [AccessD] Code help Please Hi All, I have a control txtQBInvoice I want to check to make sure that if txtQBInvoice has an existing value (an existing record) it has not changed. I know it should be something like If me. txtQBInvoice.oldvalue <> me. txtQBInvoice. New value then Txtbox Yada yada yada. I cannot find .newvalue or some equivalent for that. How do I write this please? TIA Joe Hecht Joe at anamericanjoe.us -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.9/1295 - Release Date: 2/23/2008 9:35 PM