Auto close a pop-up form after use

[ozzy68]

There is likely a simle answer to this but I cannot seem to find it.
I use a pop-up form to bring up a report after choosing a name from a drop-down list and clicking "ok". I would like the form to auto-close after it brings up the report, how do I accomplish this?

 

[Mr. B]

If you are using VBA to open the report, just add the following code to the end of the Click event of the Ok button.

DoCmd.Close acForm, "NameOfYourForm"

If you are using a macro, to open the report, add the close action to the macro after the open of the report.

 

[ozzy68]

Mr. B, your solution works great...thank you.

 

[Mr. B]

You are quite welcome.

Glad to help.