Combo box - subform

[Sherri]

Hello,

I have a problem with a form/subform in a home-grown database written by
someone no longer with the company.

There's a combo box on the main form that displays members for users to
select. When they select one, the subform is populated with the
corresponding data. (The child and master fields are linked correctly.)
However, if the mouse scroll wheel is used with the focus on the combo box,
the value in the combo box doesn't change, but the data in the subform does,
reflects a different member. So my users happily enter data into one
member's record thinking it's a different member, making a big mess.

It seems the easiest solution would be to disable the ability to scroll in
the combo box, but alas, I can find no way to do so.

Help?

 

[Ken Snell \(MVP\)]

See www.lebans.com/mousewheelonoff.htm for a way to disable the scroll wheel
in a form.