Rollback

[Tran Hong Quang]

Hi,
I'd like to have a datasheet form allowing user to edit
data, when closing, the user can cofirm the change or
cancel all change. Normally, user can only undo on record
basic.

Thanks
Tran Hong Quang

 

[Arvin Meyer]

The only way that I know that you can do that is to build a temporary table
and load the records from the "real" table to it. Make the changes to the
data in the temp table, then confirm whether you want the changes to go the
final table or be discarded. If they are to be written back, run a delete
query to delete the matching records and write them back to the final table,
then delete them from the temp table. If they are to be discarded, just
delete them from the temp table.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access