Subforms and wheel mice

[JosephYashar]

Hi,
I have a group of Form/subforms that work perfectly. However, if the mouse pointer is in the subform area and the wheel portion of the mouse is used (turned) the subform record changes. This is to the tune that the info in the subform may not match the info on the main form. For instance, in one set the main form containes client name and ID. In the subform there is info about their purchases. While editing the purchase info, if the wheel of the mouse is turned, the subform will display another client's info, while the main form is still on the first client's name and ID. The two forms are attached through the primary Key, client ID.
If I could disable that function of a wheel mouse while people are in the subforms I'd be just fine.

Any ideas on this?
I appreciate your help!!!
Joseph Yashar

 

[BriRich]

Take a look at Microsoft Knowledge Base Article - 278379

ACC2000: How to Detect and Prevent the Mouse Wheel from Scrolling Through Records in a Form

You should find everything you need there.

 

[skittle123]

that was pretty helpfull!!

It took me a while to find it on the ms site, so
heres the direct link if anyone needs it

http://support.microsoft.com/default.aspx?scid=kb;

[LN];278379