Annoying Scrolling Through Records

[Damien McBain]

Hi All,

I have a data entry form with the following properties:
Allow Edits: No
Allow Deletions: No
Allow Additions: Yes
Data Entry: Yes
Cycle: Current Record

When a user is entering a record, if they scroll down with the mouse wheel,
access goes to a new record, and they can scroll back to the previous one.

How can I stop this from happening? I want the form to stay only in the
record being created until the user clicks the save/new button, and once a
record has been created it should not be accessible from this form (there's
a data edit form for that).

TIA

Damo

 

[M.L. Sco Scofield]

Two things to try.

1 - Take a look at the form's "Cycle" property. Set it to "Current Record."
See if that solves the problem. (I can't test it because, believe it or not,
I don't have a wheel mouse.)

2 - If setting Cycle to Current Record doesn't work, you might have to
disable the wheel. (A lot of people do that in Access.) Take a look at
http://support.microsoft.com/default.aspx?scid=kb;en-us;278379 for some
background. Then go to http://www.lebans.com/mousewheelonoff.htm and
download Stephen's code and use that. Lots of people do.

Good luck.

Sco