Opening form and going to a specific field in the middle of the from

[JHB]

Hi:

I would appreciate a pointer. I have a situation where I have a macro
linked to input for a field, and have to close a form to calculate
the value of a another field. This is fine except that when I come
back and reopen the form it starts at the first tab position. I need
it to start at a field in the MIDDLE of the form which is normally Tab
Position 10.

To put it another way, the form will normally be worked by the user
from tab position 1-25 (or so) in sequence. In this exceptional case I
have to jump out of the form..do some calculations and accessing of
data, and then jump back, reopening the form. I would LIKE to jump
back to he field following Tab position10.

Can someone tell me how to do this please??

Ever thankful

John Baker

 

[Gloops]

JHB wrote, on 18th March 2012 22:05 UTC + 1 :

In this exceptional case I
have to jump out of the form..do some calculations and accessing of
data, and then jump back, reopening the form. I would LIKE to jump
back to he field following Tab position10.

Hello,

Supposing the control at position 10 is called Ctl, the most simple is :
Ctl.SetFocus

That would be fine in Form_Open, maybe in a test about OpenArgs.