First field default in form with header & details

[Roddy B]

Access 2003
When my form opens the cursor defaults to the first field in the tab order
of the Details section. Upon opening I want the form to default the cursor
to the first field in the tab order of the Form Header section. Any advise
is welcome.

 

[bhicks11 via AccessMonster.com]

Hi Roddy,

In the OnCurrent Event of the form, put:

me.whatevercontrol.setfocus

Bonnie
http://www.dataplus-svc.com

 

[Roddy B]

Hey Bonnie.
In Form properties, Event tab, On Current I inserted the code. Upon opening
the form still defaults to the first field of the details section.
Any other ideas?
Thanks!
Roddy

 

[bhicks11 via AccessMonster.com]

It worked here for me. Look at your form events and see if there is anything
running that puts it there. Also, make sure you placed the above code in the
form OnCurrent event.

Bonnie
http://www.dataplus-svc.com

Hey Bonnie.
In Form properties, Event tab, On Current I inserted the code. Upon opening
the form still defaults to the first field of the details section.
Any other ideas?
Thanks!
Roddy

Hi Roddy,

[quoted text clipped - 10 lines]

 

[Roddy B]

Yep, I placed it On Current event. The only other thing running is...

Private Sub Form_Load()
DoCmd.Maximize
End Sub

....as an On Load event. Thanks for trying!

It worked here for me. Look at your form events and see if there is anything
running that puts it there. Also, make sure you placed the above code in the
form OnCurrent event.

Bonnie
http://www.dataplus-svc.com

Hey Bonnie.
In Form properties, Event tab, On Current I inserted the code. Upon opening
the form still defaults to the first field of the details section.
Any other ideas?
Thanks!
Roddy

Hi Roddy,

[quoted text clipped - 10 lines]

to the first field in the tab order of the Form Header section. Any advise
is welcome.

 

[bhicks11 via AccessMonster.com]

Make sure the maximize is the first thing but other than that check your
other controls that might be running something.

Bonnie
http://www.dataplus-svc.com

Yep, I placed it On Current event. The only other thing running is...

Private Sub Form_Load()
DoCmd.Maximize
End Sub

...as an On Load event. Thanks for trying!

It worked here for me. Look at your form events and see if there is anything
running that puts it there. Also, make sure you placed the above code in the

[quoted text clipped - 15 lines]

 

[Roddy B]

Thanks, I will see what I can find.
Roddy

Make sure the maximize is the first thing but other than that check your
other controls that might be running something.

Bonnie
http://www.dataplus-svc.com

Yep, I placed it On Current event. The only other thing running is...

Private Sub Form_Load()
DoCmd.Maximize
End Sub

...as an On Load event. Thanks for trying!

It worked here for me. Look at your form events and see if there is anything
running that puts it there. Also, make sure you placed the above code in the

[quoted text clipped - 15 lines]

to the first field in the tab order of the Form Header section. Any advise
is welcome.