[AccessD] Code help Please

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
 




More information about the AccessD mailing list