Auto Form Close

[SiH23]

I have a button on a form which opens up a second form when pressed. The
problem however is that original form stays open behind it. How can I
automatically open and then close the previous form from a single button?

 

[Rick Brandt]

I have a button on a form which opens up a second form when pressed.
The problem however is that original form stays open behind it. How
can I automatically open and then close the previous form from a
single button?

Add one line of code to what is already there...

DoCmd.Close acForm, Me.Name

 

[Wayne-I-M]

It may be that you are passing data from the 1st form to the 2nd so open the
2nd before you close the 1st - like this


Private Sub ButtonName_Click()
DoCmd.OpenForm "Form2", acNormal, "", "", , acNormal
DoCmd.Close acForm, "Form1"
End Sub


This will not filter the 2nd form - you can add filters to the code above if
you want. - ie. Open form the a certain record, etc

Good luck