psemianonymous
Programmer
What I basically want is a way that I can reverse any changes I've made while using the form. From this bound form, I can add/edit data, but I can also (via SQL statements) delete rows. If I delete a row in some other table, and then "undo" the edit of the form, I want it to be able to "undo" the row deletion as well.
I could accomplish this if I went to a totally unbound form, but as the rest of this application is using bound forms, and my users expect to be able to use the navigation buttons, record selectors, find, and all the other things that are built in, I don't want to go to an unbound layout.
So. Using Access 97, working with JET3.5 (Access 97) tables, is it possible to open a bound form so that changes may be ROLLBACKed?
Or maybe, be able to distinguish *all instances* where the user is discarding changes to the form's data? Like if the user presses ESC, it will undo all form changes. I want to be able to trap that event. Also, if the user closes the form without saving the record (it's possible--violate the validity rules but close anyway), can I trap THAT event? And other scenarios I can't even think of right now?
Have a nice day.
Pete
I could accomplish this if I went to a totally unbound form, but as the rest of this application is using bound forms, and my users expect to be able to use the navigation buttons, record selectors, find, and all the other things that are built in, I don't want to go to an unbound layout.
So. Using Access 97, working with JET3.5 (Access 97) tables, is it possible to open a bound form so that changes may be ROLLBACKed?
Or maybe, be able to distinguish *all instances* where the user is discarding changes to the form's data? Like if the user presses ESC, it will undo all form changes. I want to be able to trap that event. Also, if the user closes the form without saving the record (it's possible--violate the validity rules but close anyway), can I trap THAT event? And other scenarios I can't even think of right now?
Have a nice day.
Pete
