Form disappear

[tinatt]

One last quick question. I've created a user login form where the user inputs their user ID and password, after the user inputs their login information though and the form opens another form, the login form does not disappear and the Main Menu opens up behind the login form. How do I make the login form disappear?

Thanks, Tina

 

[puffy89]

Add this code before your "End Sub":

DoCmd.Close acForm, "Form Name"

 

[jflachman]

In your form, you have an event that causes the main form to open. In the code for that event, put one of the following two lines:

1)If you want your log-in form to close, do this:
[tt]DoCmd.Close acForm, "FormName"[/tt]

or
2) If you want your log-in form to just be invisible, do this:
[tt]Me.Visible = False[/tt]
Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[tinatt]

Thanks very much for your help.

Tina.