Bound Access Form

[Oliver1]

Hi all,

A simple thing really we have a form bound to a query in access, when you move the wheel on the mouse it skips to the next record, which we don't want. Is there anyway to turn this off in Access, can obviosly diable the wheel in windows, but would really just like to turn it off for this one form, so the user don't accidently move to the wrong record. You may think this is unlikely but am only asking as have had so many complaints.
Any help would be great.

[RobDog888]

I'm not sure about disabling it, but this will detect it. Maybe you could move the current record back whatever
pages or records they scrolled the wheel. If the scroll commits an update then you could place code in the
Form_BeforeUpdate procedure or something?

Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
    If Page = True Or Count <> 0 Then
        MsgBox "You've moved mouse wheel." & vbNewLine & "Please dont do that!!!"'
    End If
End Sub