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"