chandlh
asked on
MS Access: Disable Auto-Update of Form except by Command Button
Hello,
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.
Thank you,
codeman
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.
Thank you,
codeman
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.