Controlling Mouse Well when on a subform

[darbid]

This one does not really bother me, but the boss wants it.

When the Parent has focus the mouse wheel scrolls through records.

He and other people move the mouse over the subform and then try to scroll. As the Parent still has focus they end up on another record. Please note I am not proposing to hinder or stop the mouse wheel, just control it a little better.

He would like it so that as soon as the mouse is over the subform that the mouse wheel then scrolls through the subform only.

I do not like so much "automatian" on a form but he would like me to see what I can do.

Has anyone thought of this before? What should I do?

 

[KenHigg]

I think the trick here is going to be to limit/prevent the main form from jumping records. Then if they wheel scroll without clicking somewhere in the subform nothing happens. I would suggest limiting it to one record at a time via it's record source query.

 

[missinglinq]

In order for the mousewheel to scroll thru the subform records, the subform control has to have the focus. Clicking anywhere on the subform control will move the focus to it and the problem is solved. But the Subform control doesn't have a MouseMove event, and MouseMove events for any part of it, once again, won't fire until the subform control has focus.

I think they'll simply have to learn to click on the subform before trying to scroll theu its records.