Keep mouse scroller from advancing to the next record?

[dlgtwice]

I have complex form with subforms that uses a combo box to select employees and then displays their vacation schedules. Everything works fine except if you hit the scroller on the mouse it advances you to the next employee and their vacation schedule.

I had a similar problem with the tab key and was able to correct it by using the cycle property and setting it to CurrentRecord.

Is there a similar way to stop the mouse scroll from doing this?

Help!

Thanks in advance for any ideas!

 

[Cheryl Fischer]

Access MVP Stephen Lebans has code at his website that will take care of
this:

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




--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have complex form with subforms that uses a combo box to select

employees and then displays their vacation schedules. Everything works fine
except if you hit the scroller on the mouse it advances you to the next
employee and their vacation schedule.

I had a similar problem with the tab key and was able to correct it by

using the cycle property and setting it to CurrentRecord.

 

[dlgtwice]

Thanks Cheryl this is exactly what I was looking for!

I had to copy the dll file into the folder out on the network because I have a front end database but it is working great!

Thanks for your speedy response! :O)