I have set up a simple login validation via this bit of VB
Dim LogonValid As Integer
LogonValid = Nz(DCount("*", "tblLogIn", "([UserName] = '" & Me("txtUserName") & "') and ([Password] = '" & Me("txtPassword") & "')"), 0)
If LogonValid > 0 Then
Forms!frmNavigation!txtUser = Me.txtUserName
Me.txtUserName = ""
Me.txtPassword = ""
MsgBox "Invalid Login"
Now I find that I need to pull another value from the tblLogIn. I need to lookup the AcctType from tblLogIn and place it on my frmNavigation in a textbox named txtAcctType.
The navigation form is always open and would provide the mechanism for me to reach back and verify that the user that is currently logged in has access to different parts of the db and forms later.
Thanks in advance.