Implement an undo for a subform

[Access2000_JS1]

I have a main form (A) with a subform that is another form with a datasheet(A_SUB)

On the form A is an undo button which rewinds any changes that occur to A that I do not wish to commit. However when I make a change to A_SUB the changes are not rewound. I considered implementing an UNDO for A_SUB but this is messy. What would be a better solution?

 

[aleb]

How about the referential integrity ....

Run the delete query if you have committed the values in table A and also committed the values in table B ( subform )