Please advise:
I'm trying to avoid a BeforeUpdate event from being triggered as a result of actions in an InputBox (within the same BeforeUpdate procedure) I use to ask the user to confirm (or deny) the outrageous value just entered. If the user does confirm the value in the InputBox, everything works okay. If the user either hits the Cancel button in the InputBox or does not confirm the input value, the code works but triggers an immediate return to the BeforeUpdate procedure. (It issues the error msg in the beginning of the subroutine that I'm missing an input value.)
I'm using EnableEvents = False, but it isn't working. The problem is in my "validity check" and my code follows:
Thanks for any help!
Bookmarks