Getting original value of text field when data entry undone with escape

[Kronix]

I have subforms that are requeried when the number in a text field on a form is changed using the AfterUpdate event. If the user presses escape on the form after making a change to the text field (regardless of whether that particular text field has focus at the time), I want to requery the changed subforms again using the original value that the field will revert to so that the subforms revert correspondingly. The problem is the Undo event happens before the text field changes back to its original value, so putting the requery into the Undo event will not result in the old value being used. How do I get it to requery using the old value? Is there an event that happens after the value reverts?

Edit: Actually, I have a subform that depends on the text field that automatically reverts when the escape key is pressed. I have a listbox, however, that does not, even though it contains calculations dependent on the text field. I need that listbox to revert the same as the subform.

 

[Ranman256]

changing data is live, if the undo cant reset to the original value, then it is lost.
unless you want to restore that 1 record from a backup.
And the backups would have to be very often.

 

[Kronix]

The undo can reset to the original value, but the undo event fires before the original value returns. I need an event that fires after the original value is set, so I can get that original value.

 

[sxschech]

Have you tried the OldValue property?

You can use the OldValue property to determine the unedited value of a bound control. Read-only Variant.

https://msdn.microsoft.com/en-us/vba/access-vba/articles/textbox-oldvalue-property-access