Need to close login form after main form displays

[RLN]

RE:
Access 2003

After the user puts in the password to log in, (in frmLogin, I am
displaying the main data entry form. That all works great, but now I
cannot close the Login form (behind the scenes) after the main form has
loaded.

Do I have to shift focus back to frmLogin after the Main form has
loaded? What is the proper syntax for shifting focus back to a form
object that is loaded in the background other than the main data entry
form the user sees?

Here is my current code:

<begin code>
if txtPassword = "xyz" then
' sucessful login...
DoCmd.OpenForm "frmMain"
DoCmd.close acForm, "frmlogin"
Exit Sub
endif
<end code>

Thanx.......
*** Sent via Developersdex http://www.developersdex.com ***

[Tom van Stiphout]

On Sat, 12 Jul 2008 12:46:26 -0500, RLN <no*******@devdex.comwrote:

That code is correct, so something else is going on. For example if
you had code in frmLogin.Form_Unload and set the Cancel argument to
True that form would not close.

-Tom.

>

RE:
Access 2003

After the user puts in the password to log in, (in frmLogin, I am
displaying the main data entry form. That all works great, but now I
cannot close the Login form (behind the scenes) after the main form has
loaded.

Do I have to shift focus back to frmLogin after the Main form has
loaded? What is the proper syntax for shifting focus back to a form
object that is loaded in the background other than the main data entry
form the user sees?

Here is my current code:

<begin code>
if txtPassword = "xyz" then
' sucessful login...
DoCmd.OpenForm "frmMain"
DoCmd.close acForm, "frmlogin"
Exit Sub
endif
<end code>

Thanx.......
*** Sent via Developersdex http://www.developersdex.com ***