Prevent Next Record When Using A Scroll Mouse

[nrugado]

I have a form that reads all of the records in an employee information table. There is a combo box that selects the record of the employee that is selected. The Combo box also filters out via a qry what positions a user has access to. The problem with this is that all of the records are in the form and the user can use the scroll mouse or the list box to change the current record. I want to disable the scroll mouse feature or any other method of changing the record other than the combo box that is provided. Any suggestions?
Thanks

 

[Gazonice]

Hi,

Microsoft Knowledge Base Article - 278379 covers this subject.

It works well, but watch out, if you use the VB Editor, you have to close and re open the database or it locks up - a nuisance esp. if you keep forgetting like I do !

Garry.

ps - sorry I don't have the actual url link

 

[Moogle]

The URL is

http://support.microsoft.com/default.aspx?scid=kb;en-us;278379

 

[Moogle]

Hmmm, the Microsoft way looks pretty difficult to use while developing, but I have worked out a way that works just as well.

On the form, in the After Insert event, add the following code.

Me.AllowAdditions = False

This will allow the one addition to be saved, and stop any other additions, either through mouse scroll, or page down.