HomePrivacy PolicyFeedbackLink to usSite Map

MS Access: Load a form into memory, but do not display it in Access 2003/XP/2000/97


Question:  In Access 2003/XP/2000/97, 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"