Tab sequence on form

  • Thread starter Thread starter Volta
  • Start date Start date
V

Volta

I have a typical Order Entry form with detail on a subform. If I tab
through the form once, the tab stops are as expected as outlined in the tab
order for both forms but any subsequent times through the form, it skips
past the first few fields in the detail line (subform) and I have to arrow
back to the first field in the subform. Any suggestions where to look or
what parameters to check to resolve this inconvenience?
 
Open the subform in design view, and choose Tab Order from the View menu.

If the form has a tab control, click on the page tab before choosing Tab
Order. Each page has its own tab order.

You might also want to check if the Tab Stop property is set for these text
boxes.
 
Sorry. This additional information would have been more descriptive and
helpful. My subform has fields A, B, C & D. I verified that they are
sequenced in that order under the View:Tab Order menu option. The fields
have the following attributes set:

A - TabStop:Yes; TabIndex:0
B - TabStop:Yes; TabIndex:1
C - TabStop:No; TabIndex:2
D - TabStop:Yes; TabIndex:3

In navigating the first pass through the form, the tabs function as
expected, but any subsequent processing (which tabs through the main form
and back to the subform again) jumps to field D and I have to backarrow to
field A.
 
When you tab from D, do you go to the main form? If yes, then the subform is
still in D when you go back into it -- moving focus from subform to main
form *does not* cause the subform to start at the first tab again -- it
stays where it was until you return. Try using the Enter event of the
subform control to set the focus to A when you put focus onto the subform.
 
I think that is probably what is happening. I have tried two different
procedures for the "On Got Focus" event of the subform: an event procedure
that uses DoCmd.GoToControl and also a macro using the GoToControl action.
Both to no avail
 
Use the Enter event of the subform control (the control - on the main form -
that holds the subform) to do this.
 
I had the same problem. Go to the forms design view and
see if you have an unbound text box. That was my problem.
 
Thank you Ken! I was applying the GoToControl to various events for the
form (On Got Focus, etc.) when I needed to apply it to, as you said, the
ENTER event for the subform. Thank you again!
 
Back
Top