Originally Posted by
Minty
@Jouneyman - you have picked the wrong event for your code, you need to do all the validation in the FORMS before update event, than you can issue a cancel = true and stop anyone leaving the form.
If you issue an Me.Undo it will undo the whole form.
Your idea of local temporary table(s) has already been discussed at length by two other responders and is almost as difficult to manage in a multiuser environment, when you take into consideration locking records being edited by someone else etc.
This is the second thread by the OP on this subject and he was finally coming round to accepting the limitations of his original approach, you are unfortunately covering old ground.