damixa
asked on
scrolling in an access form with subforms
i have a form with 2 subforms that is usually a bit longer than the page.
when the main form is active, my users can use the wheel on the mouse to scroll the page.
however when the subforms are active (when entering the info on the subforms) the mouse wheel scrolls the subform.
Is there a way, maybe some vba code or something that makes it so that the main form is always active. So in other words even when people are entering info on the subform, when the mouse wheel is moved the one who scrolls is the main form not the subform?
I know its a long shot, but thanks
when the main form is active, my users can use the wheel on the mouse to scroll the page.
however when the subforms are active (when entering the info on the subforms) the mouse wheel scrolls the subform.
Is there a way, maybe some vba code or something that makes it so that the main form is always active. So in other words even when people are entering info on the subform, when the mouse wheel is moved the one who scrolls is the main form not the subform?
I know its a long shot, but thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did which? Used the MouseWheel event or placed your subforms on tab controls?
ASKER
Did the Mousewheel event.
What VBA code did you use to allow this to work? I tried setting focus, but that is not working for me...
ASKER