Form scrolls down

[hondaman2003]

I have a form that is large enough to require people to scroll to the right and/or down to see everything. There is a requery button that is viewable with the form scrolled all the way to the top left. When this button is clicked the only command is:

[Form].Requery

After clicking this button the form scrolls to the bottom. How can I make it to the form atleast doesn't scroll anywhere or even make it scroll the form back to the top.

Runnin access 2002 with a database version 2000 on winxp

 

[TheAceMan1]

How are ya hondaman2003 . . .

Try:

[blue]   Me.Requery[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[hondaman2003]

I'm sorry, I re-read my initial post. This exact issue also happens when the form is first openned. TheAceMan1, does your response still apply? In addition how would Me.Requery help when the requery causes the issue when I have the button for that.

 

[GKChesterton]

I think the reason probably is control focus. "Tab Order" determines the order in which controls receive the focus. You may have that designated first control near the bottom of the form. The easiest way to modify this is "Tab Order" in the "View" menu.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​