Focus on forms

[lals101]

Hi,
I have a form with a series of tabs, in each tab lies a different subform. The problem I have is when the form is opened the focus is set half way down the main forms page, so that you see the entire subform, but you can't see the tab names. This is not good for data entry because the user has to scroll up to where the tabs are and the select the one they which to enter data into. Furthermore, when a new tab is clicked the same thing happens the view automatically moves halfway down the page and the user has to scroll up to see the tab names.

I looked around and found that the "setfocus" method might help, but i am unsure how to use it in this context.

thanks

 

[JamesMcS]

It might be something to do with your Tab Order. Have you checked that?

 

[lals101]

Yes it appears fine, ie it is in a logical order from top to bottom, when selecting fields.

 

[JamesMcS]

Strange. Not an ideal fix but try using [name of first control].setfocus in the form's on open event, does that make a difference?

 

[vbaInet]

This has been discussed before. Here's a quick explanation:

http://www.access-programmers.co.uk/forums/showthread.php?t=189610&highlight=tab+control