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

  • Thread starter Thread starter JHB
  • Start date Start date
J

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
 
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.
Click to expand...

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