Scrolling use on mouse skewes data entry 1

[MaddiMond]

I have created a big form and people enter data, but they are used to use the scroll "thingi" on their mouse and they accidently switch to another record and then get confused. Teh continue entering data for another record already in the database and the data gets skewed. Can I somehow stop the effect that the scrolling knob has on the form?
Thank you for your help.

 

[ProgramError]

How about changing the form properties to

data/allow additions - no
data/data entry - yes
other/cycle - current record

add a command button to save the record once it has been completed.

Private Sub SaveRecCMD_Click()
On Error GoTo Err_SaveRecCMD_Click

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    MsgBox "Record saved", vbInformation, "Title"
    DoCmd.GoToRecord , , acNewRec
    
Exit_SaveRecCMD_Click:
    Exit Sub

This will stop it.

Program Error
Programmers do it one finger at a time!

 

[ZmrAbdulla]

also see

http://www.microsoft-accesssolutions.co.uk/disable_mousewheel.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
You may be the boss' pet; but you are still an animal