No New Record

[Don Rountree]

Is there a way, through code, to keep a user from moving
to a new or previous record by using the scroll wheel on
a mouse? I'd like to keep the user on the current
record, unless they proceed to a new record through the
normal course of events I've built into my application.
Thanks...

Don Rountree

 

[Sandra Daigle]

Hi Don,

There are a couple of things you can do - first you can set the
AllowAdditions property of the form to No then assuming you are using a
command button for adding new records, include code in the button's click
event to turn AllowAdditions on. Then in the Current and AfterUpdate events
of the form, set AllowAdditions back to False.

For a way to control the MouseWheel itself you might want to check out this
code by Stephen Lebans which allows you to turn the mousewheel on and off:
http://www.lebans.com/mousewheelonoff.htm