How to stop records scrolling in bound form

[Vinod]

Hi All,

I've a bound form which has record source as query with 'Select * from tblEmp'
When I open form to add a new emp record from VBA with Docmd.Openform
"frmEmp",acNormal,,,acFormAdd statemet the form opened with empty record. In
the form footer it has two buttons 'Add', 'Close'. User has to click on 'Add'
button if he/she wants to save the record otherwise it should not.

Issue:
User made some entries in opened form but unknowingly user scrolled his/her
scroll mouse which causes to open new empty record and previous record has
been saving.

My requirement is it should not save and scroll to new record. If user wants
to create new record he/she has to open the form again from 'Main form' by
clicking on 'Add New employee' button only.

Note: I tried with form properties set to allow additions Yes and No.

Please share your thoughts and ideas in resolving above said issue which can
be appreciated.

Advanced Thanks,
Vinod.

 

[Steve Schapel]

Vinod,

The only way I know of to manage this problem is to disable the mouse wheel.

There is information and samples on this topic at
http://www.lebans.com/mousewheelonoff.htm

 

[Vinod]

Thanks Steve for your response,

As per my requirement end user will not consider any third part DLLs and
even if we use it the scrolling will be disabled when access application is
minimized and working in any other application until and unless closing the
opend form.

Apart from third party tool can we limit the mouse wheel scrolling in a form?

Advanced Thanks,
Vinod