New Record Problem when filtering

[Allison Wonderland]

I'm using Access 2003 and have what at first seems like a common problem. On
one of my forms if a user hits the scroll button on the mouse, it scrolls to
a new record which then causes problems. I don't have sufficient rights to
deploy a dll file so I got around it by changing the AllowAdditions setting
to "No". Theoretically that should have worked and indeed it does if I open
up a form directly. But in this database I often open up a form to a
particular record using the "Where Condition" argument of the DoCmd.OpenForm
command. When I do that, it opens the form to the correct record, but then
ignores the fact that I have Allow Additions set to "No" and allows the user
to create a new record. If I open the same form directly without a filter,
then it does not allow additions. Any suggestions?

 

[Klatuu]

This site has a mousewheel control that doesn't require a dll:
http://www.lebans.com/mousewheelonoff.htm