Getting a form to close in a command button

Question

I have a command button inserted on a form to take the user back to the switchboard and would like to include code after the "OpenForm" code that will close the current form upon clicking to exit to the switchboard. What code should I insert.

Answer 1

I prefer to use:

Docmd.Close acform, "formname", acSaveNo

The acSaveNo prevents design and property changes. Specifically sorts and filters. If a user applies a filter and the form is saved on close, the next user will open the form with that filter in place. So you don't want those properties to be saved.

---

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2009 Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Answer 2

As Kathy said, you need to add the arguments to the statement.

When you type the code, is should pop up the arguments you need for it in a tidy little tip style window.

---

• Doug

Answer 3

When you inserted the docmd.close statement, did you add the arguments for the object type (ie acform) and your form name that you want to close?

I just tested the following code and it worked successfully:

Private Sub Command0_Click()

     DoCmd.OpenForm "Order Details"

     DoCmd.Close acForm, "Customer Details"

End Sub

Answer 4

Thank you, but I have already inserted the DoCmd.Close at the end of the code in the command button, but it didn't close the form. That is why I checked the forum. I inserted it after the OpenForm command's error message and before the EndSub and am not sure the is where it should be located.

Answer 5

Look into DoCmd.Close

---

• Doug