Tab order on a subform

[gearhead03]

I have a form (FormCheck) that has a subform (SubFormAppliedCatergories) on it. The subform has 3 fields on it. 2 of them have to be entered for every record. How do I include the 2 fields on the subform in the tab order so they get hit every time and then switch back to the main form.

Mark A. Kale

 

[TheAceMan1]

How are ya gearhead03 . . .

Not: In the following [blue]you![/blue] substitute proper names in [purple]purple[/purple]:
[ol][li]In the [blue]On Got Focus[/blue] event of a textbox on [blue]FormCheck[/blue], se focus to the 1st textbox on the subform:

[blue]   [SubFormAppliedCatergories].SetFocus
   [SubFormAppliedCatergories].Form![[purple][b]1stSubformTextboxName[/b][/purple]].SetFocus[/blue]

[/li]
[li]Then in the [blue]On Got Focus[/blue] event of the 2nd textbox of the subform, set the focus back to the approriate textbox on the mainform:

[blue]   Forms!FormCheck![purple][b]TextboxName[/b][/purple].SetFocus[/blue]

[/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997