I have a mainform with 5 subforms in Access 2007. The Cycle property for all forms is set to Current Record. In the first 4 subforms I created an unbound textbox at the end of the tab order and placed code (sample below) in the On Got Focus event to move from one subform to the next. It works fine as long as the user does not try to use the mouse to go back to a previous subform. Sometimes it appears that the previous subform is disabled as nothing happens when clicking on any of the textboxes. Other times I receive a run-time error 2110, "Microsoft Office Access can't move the focus to the control {last subform name}.
Private Sub Text32_GotFocus()
Parent.qProgressPlan.SetFocus
Parent.qProgressPlan.Form!WorkplanComp.SetFocus
End Sub
One other note: Using the mouse I can move between subforms to my heart's content and edit any textbox. Do I have the code in the wrong event? Or is my code incorrect. Do I need to clear the focus somehow after entering the texbox? Thanks in advance for any assistance.