Tabbing through form fields

I have a form for viewing Client Details (about 3000 client records) and have
placed a combo filter in the form header to search the client list. Combo is
synchronised with record. When the form opens, the first field in the detail
area gets the focus, because it has been set up that way in the tab view. I
want the Combo in the form header to get the focus , so I wrote a piece of VB
for the form open event to docmd.gotoobject "ComboClient". This works fine
and the combo is selected for filtering purposes. After I filter to the
client , I need to tab to the first field in the detail portion of the form.
I just cant figure it. There must be a blindingly simple solution?? Your
guidance would be appreciated.
JN

Yes, the solution is simple, but not necessarily blindingly so. In the
form's Design View, look in the View menu, and choose Tab Order. Then click
on the control you want and drag it to the top. Alternatively, you can set
the Tab Index (on the Other tab of the property sheet) to 0
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jim Normile" wrote in message
...
I have a form for viewing Client Details (about 3000 client records) and
have
placed a combo filter in the form header to search the client list. Combo
is
synchronised with record. When the form opens, the first field in the
detail
area gets the focus, because it has been set up that way in the tab view.
I
want the Combo in the form header to get the focus , so I wrote a piece of
VB
for the form open event to docmd.gotoobject "ComboClient". This works fine
and the combo is selected for filtering purposes. After I filter to the
client , I need to tab to the first field in the detail portion of the
form.
I just cant figure it. There must be a blindingly simple solution?? Your
guidance would be appreciated.
JN

Mr Meyer

My Combo Box (which takes the focus on form open) is in the form header. So
when I look at tab order, the combo is shown in Form Header, while everything
else is in detail section, including the field I want to tab into, which is
already top of the list and indexed 0. So I have already done what you
suggest! - I still cant tab from the form header combo to the first detail
field (even while following your advice)............Am I missing something??

Thanks for your forbearance

JN

"Arvin Meyer [MVP]" wrote:

Yes, the solution is simple, but not necessarily blindingly so. In the
form's Design View, look in the View menu, and choose Tab Order. Then click
on the control you want and drag it to the top. Alternatively, you can set
the Tab Index (on the Other tab of the property sheet) to 0
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jim Normile" wrote in message
...
I have a form for viewing Client Details (about 3000 client records) and
have
placed a combo filter in the form header to search the client list. Combo
is
synchronised with record. When the form opens, the first field in the
detail
area gets the focus, because it has been set up that way in the tab view.
I
want the Combo in the form header to get the focus , so I wrote a piece of
VB
for the form open event to docmd.gotoobject "ComboClient". This works fine
and the combo is selected for filtering purposes. After I filter to the
client , I need to tab to the first field in the detail portion of the
form.
I just cant figure it. There must be a blindingly simple solution?? Your
guidance would be appreciated.
JN

Ahh, Form Headers are a distinct section, as are Footers. The form will open
to the first control in the Detail section. When you tab, the focus simply
moves to other controls in the same section.

Remove the controls from the Header, and put them in the Detail section. It
will then work
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jim Normile" wrote in message
...
Mr Meyer

My Combo Box (which takes the focus on form open) is in the form header.
So
when I look at tab order, the combo is shown in Form Header, while
everything
else is in detail section, including the field I want to tab into, which
is
already top of the list and indexed 0. So I have already done what you
suggest! - I still cant tab from the form header combo to the first detail
field (even while following your advice)............Am I missing
something??

Thanks for your forbearance

JN

"Arvin Meyer [MVP]" wrote:

Yes, the solution is simple, but not necessarily blindingly so. In the
form's Design View, look in the View menu, and choose Tab Order. Then
click
on the control you want and drag it to the top. Alternatively, you can
set
the Tab Index (on the Other tab of the property sheet) to 0
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jim Normile" wrote in message
...
I have a form for viewing Client Details (about 3000 client records) and
have
placed a combo filter in the form header to search the client list.
Combo
is
synchronised with record. When the form opens, the first field in the
detail
area gets the focus, because it has been set up that way in the tab
view.
I
want the Combo in the form header to get the focus , so I wrote a piece
of
VB
for the form open event to docmd.gotoobject "ComboClient". This works
fine
and the combo is selected for filtering purposes. After I filter to the
client , I need to tab to the first field in the detail portion of the
form.
I just cant figure it. There must be a blindingly simple solution??
Your
guidance would be appreciated.
JN