Ms Access - Subform Problems

READ THIS SCENARIO.... DO U HAVE SOLUTION....!!!!

User is creating or editing Orders in the Orders form provided in example Access 97 Northwind database. 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.


ANY WAY OVERCOME THIS....????

S. OBAID

Hi

You may have to use BEGIN TRANSACTION after clicking on NEW Button, and once the Save is pressed then call COMMIT TRANSACTION. If Undo is pressed you can call ROLLBACK TRANSACTION to roll back the changes.

FIRST OF ALL THANKS FOR REPLYING.... BUT UNFORTUNATELY IT SEEMS I FAILED TO LET U UNDERSTAND MY POINT..!!!

IN SUBFORM USER ENTERED THREE RECORDS BY PRESSING ADDNEW BUTTON THREE TIMES, NOW AFTER ENTERING THREE RECORDS USER DECIDED TO CANCEL ALL THESE THREE RECORDS. JUST BY ONE SINGLE CLICK. CLICK ON UNDO... CANCEL ALL THESE THREE RECORDS ADDITION.

GOT MY POINT.....????


THANKS,
S. OBAID