FROM FORM 1:
Docmd.Close acForm, "form1", acSaveNo
Docmd.OpenForm "form2"
If you have a command button from Form 1 and when clicked (OnClick - [Event Procedure]), simply put the above code above within (just the Docmd lines of code).
You want to close the form first then open where you want the user to go. Ensure to define what you are closing, the name of the item being closed, and whether to save design changes or not, etc...etc...etc...