I have a form called Main. On this form I have a subform called Sub1. On Sub1 I have 4 Tab pages.
On the main form I have a button that adds a new record. What I want to do is when I push the add record button on the Main form, the sub1 form Tab page will move to the first page if it is not already on the first page. Then I want the focus to go to a field on the main form. This is the coding in the button:
DoCmd.GoToRecord , , acNewRec