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.
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.
Last edited: