Undo and tab forms

[GregC]

I've built a tab form to handle a large amount of data entry only, no updates. A total of 11 tab pages. I 've also placed an undo button on the form that uses:

me.undo

Sometimes it works, sometimes it doesn't. How can I ensure that if the button is used the record is removed, so that the user can start over or move on to another action?

 

[boblarson]

Are ALL of the controls on the tabs bound to the form's recordset?

 

[GregC]

Ahhh...there's the problem. Thanks. I have 4 subforms that are bound to other linked tables. Once I enter a subform, the primary record is saved so that the link can be created. The result is that undo doesn't get rid of the data.

My intentions are to determine if there is a linked record. If so I will have to delete the primary record, which will take out the linked records since the cascade delete option was chosen.

Thanks