Tabbing through form fields

  • Thread starter Thread starter Jim Normile
  • Start date Start date
J

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
 
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
 
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
 
Back
Top