Tab from Form to Subform and back 1

[kirstenlargent]

I have a form with a subform. I am unable to tab from the main form to the subform. If I click in the subform, I can not tab through the records in the subform, but I can't tab back to the main form after I have tabbed through all the subform records.
The fields in the main and subform are set to be tab stops. The subform does have Allow Additions set to No. Not sure if this is causing the problem or not.
Any advice would be greatly appreciated!

 

[FancyPrairie]

If I'm not mistaken, something like ctrl+tab will move from subfrom to form. However, what you could do is put an unbound control on the subform and set it's forecolor and backcolor properties the same as the background of your subform (basically making the control invisible). Also, it needs to be the last control of the subform, Then, in the OnGotFocus event of the control, setfocus to the main form. Consequently, when the user tabs off the last visible control on the subform, the cursor will move to the main form.