access 2010. VBA to Undo changes in previous form
Posted on 2013-10-21
A bit of a tricky one here, so here goes.
I have two forms, lets call them, form1 & form2.
I enter data in form1, click next and form2 opens (form1 remains open but hidden).
Click next on form2 and all the data from form1 and form2 is then saved into various tables. Fine, this is exactly what i want.
My problem is, that if a user decides to abort the process and clicks cancel on form2, i use Me.Undo to undo form2 changes, close form2 and close form1 (from form2). However, I cannot seem to undo the changes that were made in form1 when closing it from form2.
Any suggestions please?