Using OnMouseWheel to get the next valid record from a specified t

[Scott M]

I want to use the OnMouseWheel event on my form in Access 2003 to get the
next valid record in a specified table, I'm very new to VBA, and VB
altogether, so I really don't know where to start. From my understanding,
this is supposed to be the default setting for the mouse wheel, but when I
attempt to use it I get a blank form. I think it might have something to do
with the default value of the form being programmically set, but I'm not
sure. Does anyone have an Idea on how I could write this?

 

[Linq Adams via AccessMonster.com]

The Default behavior is to move to the next record; if by "blank form" you
mean a new record (where all the fields are empty) this indicates you were on
the last record when you used the mousewheel. If you want to prevent this you
need to set your form's AllowAdditions Property to No.

 

[Scott M]

Yes, I did mean a new record, sorry...

When I changed AllowAdditions to "No" the scroll didn't work at all, i have
also added buttons using the command button wizard to use the gotorecord
command, and if the AllowAdditions is set to no, I get an error that reads,
you can not go to the specified record. I am not on the last record when the
form opens, and there are many many records in the table for this form to
display...