Tab out of a subform and set focus back on main form moving to the next record.
Posted on 2006-04-14
I have a form and a subform that are based on tables with a one-to-one relationship. The subform is NOT in datasheet vew, but rather in form view because there can be no more than one record in the subform for any record in the main form. Therefore, it just looks better having the subform in form view. Some records entered in the main form will not involve using the subform.
When a user adds a record to the main form they can tab through it and then if they continue tabbing they will enter the subform and can add a record to it. However, if they continue tabbing through the subform, when they reach the last field, they will go to another record in the subform if they hit tab. This might confuse the user. I would like the focus to go back to the main form and, if possible, go to the next record.