>In a text box on a form I am trying to put code in the valid event to prompt the user that if this field value changes then another field value will change so in the valid event I put "IF OLDVAL("{fieldname}","{tablename}") !=this.value
>" then prompt user of additional change. This works fine until the user clicks into the same field a second time does not change the value and gets the same message, which I am trying to prevent. I am using Optimistic row buffering so unless I commit my changes on the initial change, which I don't want to do, I continuously get the prompt for the change in value of the field. Any ideas?
>
>Thanks for your help!
>Stephen J. Hunt
Stephen,
One suggestion would be to add a property to the textbox and store the value in the GotFocus. When you attempt to leave, you can check that value with the value currently in the control and see if they differ. If so, you know they changed it.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao