Dear John,
Thanks for your reply.
I tried this option. But it is not giving correct result.
I am entering the purchase details using one form.
In this form new records are created in two tables (tablePurchase and tblPurchaseDetails.) and quantity fields in another table is updating.
In the...
Dear,
In the middle of data entry in a MS Access form, If the user press cancel button, the updated record in a table must be undo.
Ho it is possible.
I can delete the newly entered record, but i need to undo the updated record also.