A
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.
(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.