Referring to old_value and new_value in BeforeUpdate

[mpegjunkie]

Hello community,

is there a way to prompt the user in a form's BeforeUpdate event like "Are you sure you want to change " & old_value & " to " & new_value & "?".
The key is getting the old and the new value of a text field programmatically.
Or do I have to get them in a conventional way (reading old_value from Db and new_value from the object's .value)?

Thanks in advance,
mpegjunkie

 

[lameid]

The oldvalue property contains the old value... you can compare it to the value property or maybe even the text property. I think you want to use the afterupdate property so that the value property has the correct value for the comparison. I could be confused about needing afterupdate. It has been a while since I played with oldvalue.