How to Make a Form Invisible in Access 2007
- 1). Open the form in "Design View."
- 2). Right-click a blank area of the form. Select "Build Event." The "Choose Builder" window will open.
- 3). Select "Code Builder." Click "OK." A Visual Basic editor window will open.
- 4). Click the down-arrow in the "Object" drop-down box. Select "Form" if it isn't selected already.
- 5). Click the down-arrow in the "Procedure" drop-down box. Select "Open." Visual Basic should create the following code:
Private Sub Form_Open(Cancel As Integer)
End Sub - 6). Add the following line between the two lines of code, replacing "frmAddresses" with the name of your form.
Forms!frmAddresses.Visible = False - 7). Save your code changes. Close the window.
Source...