MS Access: Disable Auto-Update of Form except by Command Button
Posted on 2004-04-07
I have a simple form that displays the contents of a table ( via bound control ).
I also have a command button, caption: Update.
I would like to disable/intercept the Auto-Update feature of the form to ONLY update when the user presses the update button. I do not want the record updated when the user closes or moves to another record within the form (table).
I have looked for several days for the solution and it is either too simple or seldom requested.
If there is a different approach to accomplish the same thing, then please feel free to suggest.