Table Update problem

[irishjoe]

Hi,

I have a form that contains text boxes that are bound to a table. When I enter new data in the text box, the database automatically adds the new data to the table. After reading Pat Harman's solution, I thought the best way to fix this problem was to, when the form is loaded, store all the variables and if the user clicks cancel, I restore the original values on the screen and save.
I have 2 buttons on the screen, cancel and save. The menu and all menu buttons have been removed so these are the only buttons available to the user.
This works fine but the code is not reusable for multiple forms.
Does anyone have any ideas as to how to make a procedure out of this? I have about 30 forms that work this way and I was wondering if it was possible to make a procedure that would get all the information in the text boxes, store them in an array and when needed, restore them to the current form.

 

[Rich]

Why not just use Me.Undo if the user clicks cancel?

 

[irishjoe]

Thanks very much! I spent about about 10 hours trying to fix this problem. I have about 70 lines of code and you did it on 1!!! I feel like a right plonker...

Thanks again,
Joe.

 

[Pat Hartman]

I don't believe that I've ever suggested an unbound form as a solution for controlling updates.

 

[irishjoe]

Pat,
You didnt suggest doing the solution the way I did, I meant after reading a page that you and also ghudson mentioned a database called mouse trap, i came up with the idea of a manual undo button. This was before I knew that access had a built in undo function...
Sorry if I confused you with my post.