Tab order incorrect

[Mike W.]

Hi y'all,

I have a form on which I am trying to set the tab order.

I can change the order of all of the tabs, but I cannot change the item that
opens first on the form. No matter what number I put on it in tab order line
in properties, or if I move up or down in the tab order list in design view,
it is the first item when the form opens in the application. Obviously, it
is not the one that I want to be first.

The offender is a bound text box on a form with a bunch of text boxes (bound
and unbound), commands, calendar controls, and combo boxes.

Access 2003 on XP Pro Service pack 3.

Any ideas?

Thanks much,

Mike W.

 

[Jeff Boyce]

Mike

If the same control always receives the focus when the form first opens, no
matter what tab order you have set, I'm guessing there's a spot of code in
the Open (or Load, or Activate) event that specifics THAT control to get the
focus ... i.e., something like:

Me!ThatControl.SetFocus

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Correction ... " ... that specifies THAT control ..."

Jeff

 

[Mike W.]

Brilliant!

I found it in the code, couldn't see any reason that it needed to start
there, changed it to the box that I wanted to be first, tested it and voila!

Thanks much,

Mike W.