Nothing here.  Try again.

This is the code.  I reversed the code so that it closes the logon screen then opens the next screen.  The other way where it opens the lognon then closes  it does not clear the username and password.  I tried closing access and reopening.  It still keeps the username in the field and asterisks in the password screen.  

What I like is code for blanking out those fields.

Nathan Shepard

Option Compare Database
Option Explicit
Private Sub CancelBtn_Click()
DoCmd.Quit
End Sub

Private Sub LogOnBtn_Click()
Dim PW As String
If IsNull(UserName) Then
          MsgBox "Invalid UserName"
          Exit Sub
End If

If IsNull(Password) Then
MsgBox "Invalid PassWord"
Exit Sub
End If
PW = Nz(DLookup("PassWord", "LogOnT", "UserName=""" & UserName & """"), "")
'                                                  PW = Nz(DLookup("PassWord", "LogOnT" , "UserName=""" & UserName & """"), "")



If PW = Password Then
    
    DoCmd.Close acForm, Me.Name, acSaveYes
     DoCmd.OpenForm "MasterMenuF"
    Else
    MsgBox "Invalid Logon"
    End If
    End Sub
  

Nathan in design mode -
Make sure your text boxes in the form are unbound for both the Username and the Password.
Second, did you set a default value for either of those?  (property sheet:  Data tab > Default Value)
If so clear that line.  
Otherwise the form itself isn't bound to anything and the fields are not bound to anything you should not be having anything automatically load.  

Scott
I will put some money in my paypal account.  It takes about four days for the transfer.  By the way.  I followed your instructions and it works great.  Thank you.

If any other moderator remembers they gave me assistance.  send me an email at [email protected].  I will see to it you are paid.  Jeff

Super deal!  So glad that worked out for you.  I'm glad to help.