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).
See solution in other versions of Access:
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"
Advertisements