Tab Stop won't move to next stop order

[Guest]

I have a simple form with 12 fields in the Detail section - no subforms
I have set the tab order but when I try to tab from stop number 3 to stop 4,
the cursor pops back to stop 1 instead of to stop 4. Curiously, the table
it's connected to has a compound key and tab stop 3 just happens to be the
last field in the table key (i.e. the tab order seems to be limited to the
key of the table) I've set the tab order using View-Tab order and using the
properties menu for each field - doesn't fix it. How do I get the cursor to
move from stop 3 to 4?

 

[Tony Vrolyk]

Check the offending controls and make sure their Tab Stop property is set to
Yes. It is under the Other tab on the property sheet.

Tony V

 

[Guest]

I checked that - Tab Stop properties were set to Yes on all fields

 

[Tony Vrolyk]

Is there some code on the Form (On Current maybe) that is requerying or
changing focus?
Does that last control that tabs correctly have code under it to move focus
to the first control?
Are the other controls disabled (Enabled = False)?

 

[Guest]

YES - there is a requery which executes when exiting the the offending field
(tab stop 3)
That seems to be the problem - is there a simple work-around for that?

 

[Tony Vrolyk]

If you need the requery to stay then add a setfocus line after the requery

Me.Textbox4.SetFocus