Continuous Subform Undo

[Georgina]

Hi

I have a form and a linked subform which are linked by Purchase Order Number. When items have been delivered on the purchase order, the user should update the continuous subform with the number of items that have been delivered. This works fine.

The problem I have is using an exit button that does not save any of the changes to either the data in the form or the subform. It doesn't matter if there is a prompt to alert the user that there have been changes made.

I have been messing around with DoCmd.RunCommand acCmdUndo in the on click event of my exit button which kind of works when changes has accidentally been made, but is very unsophisticated - any ideas?!

Thanks

Georgina

 

[Pat Hartman]

There are lots of posts here on this topic. The important thing to understand is when Access saves the current record. Only then can you control it. This link should get you started.