Undo Multiple line Edits/Add/Delete in Sub form

[Syed Ubaid]

Hi,

I have a problem in Main / Subform.

===========================================================
Scenario:

User is creating or editing Orders in the Orders form
provided in example Access 2.0 Northwind Traders database
NWIND.MDB). User edits order information in the main
form and edits/adds/deletes multiple line items in the
subform, then decides to abort the editing. Microsoft
Access has already committed the main form record to
the Orders table as well as the multiple line item edits.
Undo from the Edit menu is not available.
===========================================================

Now I want to Undo this Add/Edit/Delete in Subform if user
press Cancel or Undo button in Main form to cancel any
update (in Main or Subform). Microsoft has already provide
a solution for MS Access 2000 or later by creating a
temporary table, which held record temporarily before
inserting/updating in real table but I need some other
solution.
Any possiblity.

Thanks.

Syed

 

[Guest]

with the same idea as the temporary table, but use a recordset to hold all the records and you could refer to it to backout (rollback)

 

[msnews.microsoft.com]

I would appreciate if you or some other could provide
me code for the same.

Syed


with the same idea as the temporary table, but use a recordset to hold all
the records and you could refer to it to backout (rollback)

 

[John Vinson]

I need some other solution.

You've gotten three posted on the newsgroup over the past three of
four days. Did you see them? any comments about them?

 

[Syed Ubaid]

Hi,

I have a problem in Main / Subform.

===========================================================
Scenario:

User is creating or editing Orders in the Orders form
provided in example Access 2.0 Northwind Traders database
NWIND.MDB). User edits order information in the main
form and edits/adds/deletes multiple line items in the
subform, then decides to abort the editing. Microsoft
Access has already committed the main form record to
the Orders table as well as the multiple line item edits.
Undo from the Edit menu is not available.
===========================================================

Now I want to Undo this Add/Edit/Delete in Subform if user
press Cancel or Undo button in Main form to cancel any
update (in Main or Subform). Microsoft has already provide
a solution for MS Access 2000 or later by creating a
temporary table, which held record temporarily before
inserting/updating in real table but I need some other
solution.
Any possiblity.

Thanks.

Syed