Susan Harkins
ssharkins at setel.com
Mon Feb 19 14:32:52 CST 2007
Only that I wasn't paying close enough attention. The properties were working just fine. :) Look up the form Before update event in Help -- there's just a smidge in there about they maintain their values in this event, which is where you'll probably use them. Susan H. Susan, Did you find anything else about this? Actually I did not know the property existed. I have always used variables or the tag property to store this. I was going to start using it and an associate says there are also problems with checkbox booleans and comboxes. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us ----- Original Message ---- From: Susan Harkins <ssharkins at setel.com> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> Sent: Sunday, February 18, 2007 6:12:37 PM Subject: [AccessD] Value verses OldValue I ran into something interesting with the following expression: If ctl.Value <> ctl.OldValue Then It appears that unless you've changed the value, ctl.Value is empty. If there's been no change, shouldn't Value and OldValue been the same? Why is Value empty? This is in a form's Before Update event, which might matter. Susan H. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ____________________________________________________________________________ ________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097 -- 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.441 / Virus Database: 268.17.39/687 - Release Date: 2/14/2007 4:17 PM