Close the Switchboard when opening a form

[Silvera]

I have never used a switchboard and have no clue how they work. I've been asked to do some modifications to an existing database. I've done just about everything needed. There are some instances when some windows open and you can still see some or all of the switchboard, which I think is sloppy. I want to close the SB when opening a form and then after all the steps of the programing task are completed I will reopen the SB.



But 1st I have to close it.

It seems like a simple task but...
When a form opens from the SB I've tried the following:
DoCmd.CloseForm "Switchboard"
DoCmd.Close.Form "Switchboard"

I have this code for closing a form or finishing printing a report:
Private Sub Whateveritis_Click()
DoCmd.Close
DoCmd.OpenForm "Switchboard"
End Sub

[John_G]

The correct syntax is DoCmd.Close acForm, "Switchboard"

[Silvera]

Thank you John_G! I'm so use to DoCmd.Close I totally for got about "acForm" and did not notice the dropdown all the times I tried before. When I went back to make the proper entry there was the dropdown with "acForm" listed.

[Micron]

Maybe you should just hide it? A switchboard is usually used like a background window that's full size. If another form opens on top of it but does not cover the switchboard entirely because the second form is smaller, it shouldn't bother anyone anymore than having parts of the Access window visible as you create. Every time you open this, code will run, which may not be problematic or slow for your application. Where you will probably run into an issue is when your code execution takes an unexpected path and you try to close a form that is already closed, or vice-versa, or you just forgot what state it was in when you invoke the command. You will get an error saying Access cannot find your form if it is already closed, but should not if you hide/unhide-maximize.