Trying to SetFocus to right field in form

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

Put the following code in the Open event of your form:

Me!NameOfFieldInHeader.SetFocus

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"JustMe" wrote in message
. ..
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

I wish to Thank You Very much...
It worked...

"PC Datasheet" wrote in message
ink.net...
Put the following code in the Open event of your form:

Me!NameOfFieldInHeader.SetFocus

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"JustMe" wrote in message
. ..
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