---

MS Access 2007: Load a form into memory, but do not display it

This MSAccess tutorial explains how to load a form into memory that is not visible to the user in Access 2007 (with step-by-step instructions).

Question: In Microsoft Access 2007, I need to load a form into memory, but not show it. How can I do this?

Answer: To load a form into memory, but not have it be visible, you can try the following VBA code:

DoCmd.OpenForm "Categories Form"

Forms![Categories Form].Visible = False

This code will load a form called Categories Form. Then it will make the form invisible, so that the user can not see it.

You can then close your form with the following VBA code:

DoCmd.Close acForm, "Categories Form"