Closing previous form after opening new one

[Gilberto]

Hello

This must be pretty simple but i havent found the way to do it.

I have a form with a button that opens another form on click. WHAT command and WHERE do i need to CLOSE the previous form (first form) after clicking the button the opens the new one??

Ive tried docmd.close in several events but it doesnt work.

Thanks,
Gilberto

[MikeTheBike]

Hello

This must be pretty simple but i havent found the way to do it.

I have a form with a button that opens another form on click. WHAT command and WHERE do i need to CLOSE the previous form (first form) after clicking the button the opens the new one??

Ive tried docmd.close in several events but it doesnt work.

Thanks,
Gilberto

Hi

I think what you need is this

DoCmd.Close acForm, "NameOfFormToClose"

or even

DoCmd.Close acForm, Me.Name ?

Somewhere after the Open form command.

MTB

[missinglinq]

On the button on your first form

Private Sub OpenSecondForm_Click()
    DoCmd.OpenForm "SecondForm"
    DoCmd.Close acForm, "FirstForm"
End Sub
 

Linq ;0)>

[Gilberto]

On the button on your first form

Private Sub OpenSecondForm_Click()
    DoCmd.OpenForm "SecondForm"
    DoCmd.Close acForm, "FirstForm"
End Sub
 

Linq ;0)>

Thanks Linq this worked perfectly.