I've created a data entry form that is comprised of the main form and three subforms. Each form updates a separate table. Once the record is saved from the main form via the [Next] command button, I'd like for the focus to go to the first control in the first subform and the same process upon clicking the [Next] button in the first subform to the second and then the third. I've tried the following code, which works from the Main form to the first subform, but craps out after that and I receive an error that the second subform cannot be found, etc.
Code for the OnClick property of the [Next] command button:
Me![Subform1].SetFocus
Me![Subform1].Form![DataField1].SetFocus
Help!