
Signature
Wayne
Manchester, England.
> i have a table with an underlying table. when i move the wheel of the mouse,
> the form moves to another record or a blank record.
[quoted text clipped - 7 lines]
>
> thanks for your help
There are a couple of hacks out there do do this, but the reference Wayne
gave you really is the gold standard. After downloading the sample database,
take a look at it. Then go into your target database and goto
File > External Data > Import
and import the module modMouseHook from the sample database. Next make sure
you have the included file, MouseHook.dll, in the same folder your database
resides in. The following code needs to run before the mousewheel will be
locked:
Private Sub Form_Load()
'Turn off Mouse Scroll
blRet = MouseWheelOFF
End Sub
If you have one form that always loads first in your db, place the code there.
If the first form to load varies, place the same code in each form. Once
turned off, it'll remain off until you turn it back on or exit the
application.
Unfortunately, the scrollwheel is either on or off, so you can't have if off
except when you want to scroll in a textbox/memo field. If you turn it back
on when you're in a textbox, you'll get the behavior you're trying to prevent,
with it scroll to another record.
Linq

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003