Closing a Form

[erick-flores]

Hello all

I have multiple forms, these form interact with each others using
buttons. I want to close Form A everytime I click on a button to open
Form B. So i dont have multiple forms open at the same time.

I know the code, to close the form, needs to be put under the On Click
Event button that opens the next form, but dont know how to write it

Thanks

[pietlinden]

something like

Public Sub CloseMyform()
DoCmd.OpenForm "Form2", acNormal
DoCmd.Close acForm, "Form1", acSavePrompt
End Sub

but you'd put the code
DoCmd.OpenForm "Form2", acNormal
DoCmd.Close acForm, "Form1", acSavePrompt
in the click event of your button.

judging by your questions, you would probably learn a lot from opening
a code module and poking around in VB help. Play with Northwind.
That's what it's there for.

[erick-flores]

Thanks for your reply, I will try the code

And whats that Northwind??? where is it???