Record Navigation and Everyone's Friend the Wheel Mouse
Posted on 2007-07-30
I want to handle a wheel mouse within my Access application but I don't want to disable it. I've been using the Lebans soltution for a long time but I've found it works best when you turn off the wheel mouse right away, which disables it everywhere else, including spots where you'd like it to work.
I NEVER navigate through records in my forms. When editing a record, I open the single record using an underlying query for that record only and open the form using acEdit, with AllowAdditions off. The hell mouse isn't a problem there. When adding a new record, I open it as acNew using the same form. With the lebans mousehook in place, it does prevent the user from scrolling to another new record, but as I said before, I don't want to keept turning it on and off because it gets messed up.
Basically, I just want to open this form with acNew and allow only one new record to be added. My solution was to set AllowAdditions to false on the fom's AfterInsert event. This worked, but forced the update of the record. This creates a problem because if I have a user who opens the form, doesn't end up wanting to save what they did and clicks Undo (Me.Undo), the record has already been saved with nothing in it because I set AllowAdditions to false (I don't know why that happens but it does) and I have a ton of bogus records.
So, considering I never want the form to move from record to record, how do I stop Access from doing it without having to jump through a bunch of hokey hoops.