Hey
I want a simple login screen for my access file.
I have it all working with users in a table.
this code works fine
If Me.txtPassword.Value = DLookup("Password", "Access_Table", "[User_ID]=" & Me.txtUsername.Value) Then
lngMyEmpID = Me.txtUsername.Value
'Close logon form and...