Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Undo form/recordsets

Status
Not open for further replies.

scoobey

Technical User
Sep 18, 2001
32
GB
Hi all
I am looking to cancel all record changes on a form, but keep having issues with records still being saved.
I have a form which loads a table, with several records in the table. If I make a change to the first record, and then move on to the next record and make a change there (and so on), if I use my me.undo or form.undo button and close the form, the next time I open it it has only 'undone' the record I was last on, and not all subsequent ones.
Basically, I'm looking for a way to undo all changes on a form, regardless of how many records I have changed. A kind of 'super undo' button to undo all changes to all records on a form. Is this possible? Help - it's driving me mad!!!!
 
1. Create a temp table that will contain only the data you see on the form.
2. Place two buttons on the form: (1) Save (2) Cancel All
3. Create a query (or code) so that if the user clicks 'Save', it will update all of the data in your main table(s) with the changes.
4. Cancel button would refresh the temp table back to the original values.

"Have a great day today and a better day tomorrow!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top