update cancelupdate

[asc4john]

Most of the forms I use are for data viewing. However when a user
(with premissions) clicks addNew
AllowAdditions and AllowEdits is true and the user can add the new
record and modify it.
The problem: 1) I want to have a cancel button and an update button.
Update works fine. Cancel however, using rst.cancelUpate causes an
error to the effect that rst.Edit or rst.addNew wasn't used.
I used DoCmd.goto addNew to add the new record. Whats happening since
Update works?
2) Also I found while in "Modify Mode" tabbing or the mousewheel will
update the record by moving off it. How to disable tabbing and the
mousewheel.

 

[missinglinq via AccessMonster.com]

1) On your Cancel button, a simple Me.Undo should surfice.

2) To chane the behaviour of the Tab button you need to goto:
Tools > Options > Keyboard > Move After Enter
and change this from Next Record (where it apprarently is set) to Next
Field or Don't Move
3) The best hack for disabling the wheel is from Stephan Lebans at:

http://www.lebans.com/mousewheelonoff.htm

Just be sure to download the zipped db and Import the module from it into
your db before trying to use the use he provides on his site.