I built a username and password form like the one in the tech help video "User level Security" and wrote the code exactly as it was in the video. When I was setting up the users in the user table, I left the password blank and figured I would add them later. When I added some passwords and tested again it would allow me to log in with just the username. I didn't have to enter the password that was in the table, I could just leave it blank and it would still logon. I went back to the video to see if that combination had been tested in the video and it hadn't been. I am just getting started with code writing and do not have enough experience to know why this is happening. I included the code that I wrote for my button below. Can someone test this for me to see how I need to change it so the password has to be entered if there is a password in the table.

Private Sub LogOnBtn_Click()
    Dim ID As Long, PW As String
    
    ID = Nz(DLookup("UserID", "UserT", "UserName=""" & UserName & """"), 0)
    If ID = 0 Then
        MsgBox "User not found"
        Quit
    End If
    
    PW = Nz(DLookup("Password", "UserT", "UserID=" & ID), "")
    If PW <> Password Then
        MsgBox "Incorrect Password"
        Quit
    End If
    
    TempVars("UserName") = UserName.Value
    DoCmd.OpenForm "UserF"
    DoCmd.Close acForm, Me.Name, acSaveYes
End Sub