Stop Tabbing From Main form to sub

[stu_c]

Hi all
I have a main form with a sub form on it, is there a way to stop the last field in the main form tabbing into the sub form?
in the design > Tab Order it is showing the sub form so is there a way to remove this?

currently I have done it a bit of a crude why using a tiny text box it tabs to after then used .setfocus to return back to the first Field

 

[GaP42]

Check - subform properties: Tab Stop - "no" should do it

 

[theDBguy]

You could also try setting Tab Cycle to Current Record to see if it helps.

 

[Pat Hartman]

The cycle property applies to scrolling to a different record on the same form.

To prevent tabbing into a subform, you can add a tiny control to catch the tab out of the last control on a form and then in the on Exit event of that tiny control, place focus back into the last control or the first control which ever makes sense to you.

Make sure the tiny control's border and background are set to transparent.