close one form when another is opened

K

Kayla

what is the code that is used on a command button that
when it is clicked, the form in view is closed and opens
another form. For example form A and form B. when the
control on form A is clicked, form A is saved and closed
and form B opens. Thanks
 
R

Rick B

I just answered this about two days ago. Do a search.

The answer given was...

Private Sub SomeButton_Click()
DoCmd.Close acForm, "MainFormName"
DoCmd.OpenForm "SecondFormName"
End Sub





Rick B


what is the code that is used on a command button that
when it is clicked, the form in view is closed and opens
another form. For example form A and form B. when the
control on form A is clicked, form A is saved and closed
and form B opens. Thanks
 
Top