Upon form open, cursor into specific field at top?

  • Thread starter StargateFanFromWork
  • Start date
S

StargateFanFromWork

One of the annoyances with a couple of dbs we have is that once we open the
form, we always need to click into the first field. Is there a way to get
A2K to navigate to right starting point when user opens a form so that once
it's open, we're ready to go? Otherwise, pain in the neck as we need to
open various forms in any given session.

Thanks! :eek:D
 
D

Douglas J. Steele

Set the Tab order so that the desired field is first. (under View | Tab
Order when the form is open in Design mode)
 
R

Rick Brandt

StargateFanFromWork said:
One of the annoyances with a couple of dbs we have is that once we open the
form, we always need to click into the first field. Is there a way to get
A2K to navigate to right starting point when user opens a form so that once
it's open, we're ready to go? Otherwise, pain in the neck as we need to
open various forms in any given session.
Click to expand...

Make the desired control have TabIndex of zero. That should make it have focus
when the form is opened.

To make it move to that control every time you navigate place code in the form's
Current event...

Me.ControlName.SetFocus
 
S

StargateFanFromWork

Rick Brandt said:
Make the desired control have TabIndex of zero. That should make it have focus
when the form is opened.
Click to expand...

Okay, if you mean by setting the control to have a TabIndex of zero meaning
that it's first in the tab order, it is! <g> That is what is so baffling.
Yet when the form opens, the cursor is in the second field, the one second
in place in the tab order. Fortunately, was able to figure out the code
below.
To make it move to that control every time you navigate place code in the form's
Current event...

Me.ControlName.SetFocus
Click to expand...

Thank you so very much for pointing me in the right direction. I didn't
know what to do here but now with the above as keywords was able to find in
archives (thank god for those archives! <g>) another msg dealing with this
and found this code in a working example:
http://groups.google.ca/group/micro....ControlName.SetFocus&rnum=2#801e0532b97168c1.

(For other newbies ... Everything is easy once you know how <g>). I
clicked in the box at the upper left-hand corner of the form and went into
design view. In the properties of the form, at the top of the "Event" tab
is a field labelled "On Current". I chose "Event Procedure" from the
pulldown and clicked the ellipsis (...) that brought me to the vbe and to
the lines newly created for this event. In the page above, I got this code
to put in there:

Private Sub Form_Current()
CIDR.SetFocus
End Sub

Which because reading through I knew "CIDR" was that poster's control name.
I subsituted the name of the control I am dealing with right now, "DocketID"
so that mine looks like this:

Private Sub Form_Current()
DocketID.SetFocus
End Sub

And now whenever I open that form, the cursor is where it should be, in the
field labelled "DocketID". ...)

Thank you so very much!! This job is still in the stages where there is so
much to do that every second we can shave off, every frustration or
aggravation we can make smaller even if by only a little bit is a blessing.
This will save our sanity just that bit more! Applying this process to our
other forms. :eek:D
 
Top