Can I Undo a record in a form and subform with one command button? 1

[Reghita]

Hi Guys

I have added an Undo command Button on a Parent Form, and it's works fine for that Parent form only. but is there any way that i can also undo a record in the subform using one cmd Button?

can someone direct me in the right direction

Thanks Heaps

 

[AmiDenise]

The best solution for this is to start a transaction when the form opens and commit it after each record it saved. That way, you can rollback the transaction (undoing the action) on both the main form and the sub forms.

The following MSKB articles explain the problem you're encountering and offer code samples for the solution that they (and I) recommend.

ACC: Main Form Record Edits Saved When Subform Gets Focus

http://support.microsoft.com/default.aspx?scid=KB;en-us;q132033

ACC: Unable to Undo or Rollback Main Form and Subform Changes

http://support.microsoft.com/default.aspx?scid=kb;EN-US;131535

Hope this helps! Good Luck!
Ami D. Shroyer, MCP
amidenise@yahoo.com

http://www.amidenise.com