How do I set subform to stop it jumping up screen when clicked?

[Dazzman]

I have a form with 3 subforms.

When I click onto one of the subforms it jumps up to top of screen instead
of remaining where it was...this gives users job of scrolling back up.

Irritating.

 

[Al Campagna]

Dazzman,
Sounds like you have a Requery, or GoTo First programmed in the subform
OnEnter... or something similar.
Stephen Lebans has a SetGetSB routine that allows for a continuous
subform Requery, and returning the focus and subform to it's original
position after that Requery.
I've used it with success for some time now...
http://www.lebans.com/setgetsb.htm
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Maurice]

Check to see which field gets focus first when you click on the form. Make
sure the first field is getting focus first (tabstop index)

hth