Tabbing through form fields

[Jim Normile]

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

 

[Arvin Meyer [MVP]]

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

 

[Jim Normile]

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]]

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