Tab to next subform

[BLW]

I have a form (frmAssessments) with three subforms(sfrmAssess1, sfrmAssess2,
sfrmAssess3). I want the user to enter data into the main form and then be
able to tab to the fields of each subform and enter data.

I got it to the point where they can tab to the first subform, but once you
get to the last field of that subform - tab puts you back to the first field,
new record.

I have looked through the forum and tried several things from other
questions without any luck.

Any hlep you can give would be greatly appreciated.

 

[Allen Browne]

Perhaps you could add another tiny unbound text box to the end of the tab
order for the first subform. Use the Enter event of this control to jump to
where you want to go.

The event procedure code would need to:
- save any edits in progress
- set focus to the main form
- assign a value to the tab control (for the desired page)
- set focus to the next subform control
- set focus to the desired control within that form.