Lock vertical scroll bar

[Guest]

Hi there!

I have a form with a sub. When I tab off the last text box on my main form
to the first control on the sub, the main form wants to sroll down and as
such, I have to scroll back up to see the buttons which have been hidden. I
did a me.requery on the last text box but this takes me to the first record.
So, how can I temporarily lock the vertical scroll bar (no horizontal)?

Thanks for all your help!
--

 

[Marshall Barton]

I have a form with a sub. When I tab off the last text box on my main form
to the first control on the sub, the main form wants to sroll down and as
such, I have to scroll back up to see the buttons which have been hidden. I
did a me.requery on the last text box but this takes me to the first record.
So, how can I temporarily lock the vertical scroll bar (no horizontal)?

No can do. Access works very hard to do whatever it can to
make the control with the focus visible.

Either make your subform shorter or the main form's window
taller.