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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dazzman - 15 May 2008 11:50 GMT

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.

Reply to this Message

Al Campagna - 15 May 2008 13:29 GMT

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

Signature

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."

>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.

Reply to this Message

Maurice - 15 May 2008 13:31 GMT

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

Signature

Maurice Ausum

> 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.

Reply to this Message