There are many articles on how to disable the mouse wheel in MS Access. In my opinion we need to embrace the fuctionality of the mouse wheel in MS Access but at the same time provide some control over what the mouse wheel and other buttons do in form view.

In MS Access 2000/2002/2003 for example, if you have a form and do not want users to mouse wheel to the next record to create a new one, the answer can be found in a simple Event code.

To disable the mouse wheel and page up and page down buttons, open your form and in the "On Current" event enter this simple vb code...

Private Sub Form_Current()
DoCmd.GoToRecord , , acFirst
End Sub

This should stop users from scrolling to the next record and creating a new record. This may be obvious and simple, but its very effective for me!

I looked around for hours at all the fancy module examples but none of them worked for me, I like simple solutions! maybe you do too!