Trying to SetFocus to right field in form

[JustMe]

Hi All.. And PLEASE don't say it...I know it's posted elsewhere...
Some people MIGHT look at one newsgroup and not others and will have the
answer...Sorry

Here is my orig Question, and it was responded to by Jeff but what was given
did nothing but get me a Macro Error message.
Mabey someone els knows.. I have searched the MS Knowledge Base but found
nothing that helps there.

I have a form called MainFrom. When I open this form it has a subForm that I
use to lookup Customers. My problem is when I open this Main form it's focus
is to the center or the Detail section of the form. I need to First fill
some data in the Header section.
How do I set focus that when I open The Main form it First lets me enter the
data
in the header part of the form? I can click the mouse in the first field and
that works but I shouldn't have to do that....I don't think.

I have looked at the Tab settings and it does not let me do anything but
change tab order of the fields, Not Sections.
Any Ideas?

Thanks

 

[Rick B]

If you must post into more than one newsgroup, enter all the groups into the
"newsgroup" field when adding it. This will post copies in the other
groups. If one is updated, they all reflect it.

Rick B

Hi All.. And PLEASE don't say it...I know it's posted elsewhere...
Some people MIGHT look at one newsgroup and not others and will have the
answer...Sorry

Here is my orig Question, and it was responded to by Jeff but what was given
did nothing but get me a Macro Error message.
Mabey someone els knows.. I have searched the MS Knowledge Base but found
nothing that helps there.

I have a form called MainFrom. When I open this form it has a subForm that I
use to lookup Customers. My problem is when I open this Main form it's focus
is to the center or the Detail section of the form. I need to First fill
some data in the Header section.
How do I set focus that when I open The Main form it First lets me enter the
data
in the header part of the form? I can click the mouse in the first field and
that works but I shouldn't have to do that....I don't think.

I have looked at the Tab settings and it does not let me do anything but
change tab order of the fields, Not Sections.
Any Ideas?

Thanks

 

[Rick B]

In the form's OnOpen property enter...

SomeFieldName.SetFocus





Hi All.. And PLEASE don't say it...I know it's posted elsewhere...
Some people MIGHT look at one newsgroup and not others and will have the
answer...Sorry

Here is my orig Question, and it was responded to by Jeff but what was given
did nothing but get me a Macro Error message.
Mabey someone els knows.. I have searched the MS Knowledge Base but found
nothing that helps there.

I have a form called MainFrom. When I open this form it has a subForm that I
use to lookup Customers. My problem is when I open this Main form it's focus
is to the center or the Detail section of the form. I need to First fill
some data in the Header section.
How do I set focus that when I open The Main form it First lets me enter the
data
in the header part of the form? I can click the mouse in the first field and
that works but I shouldn't have to do that....I don't think.

I have looked at the Tab settings and it does not let me do anything but
change tab order of the fields, Not Sections.
Any Ideas?

Thanks