I tried searching for this and couldn't find anything (tried a bunch of combinations of "auto-scroll", etc)
I have a main form that contains a tab control, and in one of those tabs is a subform.
When I click on the tab that contains the subform, Access scrolls the window so that the subform is at the very top-left. When I am done with that subform and want to move to the next tab, I have to scroll up in the main form. This is highly undesirable, because I am going to be using this form while on the phone, and I want to minimize scrolling.
I realize that this is because Access automatically scrolls to the control that has the focus. Is there a way to prevent this, either by disabling the auto-scrolling or by making the main form's scroll position stay at the top-left?
I'd really appreciate it if there were a way to do this with just control and form properties, as I have quite a bit of VBA on the form already, but any solution would be appreciated.
I have a main form that contains a tab control, and in one of those tabs is a subform.
When I click on the tab that contains the subform, Access scrolls the window so that the subform is at the very top-left. When I am done with that subform and want to move to the next tab, I have to scroll up in the main form. This is highly undesirable, because I am going to be using this form while on the phone, and I want to minimize scrolling.
I realize that this is because Access automatically scrolls to the control that has the focus. Is there a way to prevent this, either by disabling the auto-scrolling or by making the main form's scroll position stay at the top-left?
I'd really appreciate it if there were a way to do this with just control and form properties, as I have quite a bit of VBA on the form already, but any solution would be appreciated.
