need help with user name login

[wilson76]

hello guys i need help for username login info
i have a table of usernames that include username for usernames userpass for password and usershow for users full name i want to show users full name in main menu after they login my login button code is

Private Sub cmdlog_Click()
If IsNull(Form_frmlogin.txtuser) Then
    MsgBox "enter user", vbInformation, "adam vorood"
    Me.txtuser.SetFocus
    Me.txtuser.BackColor = vbYellow
    Exit Sub
End If
Me.txtuser.BackColor = vbWhite
If IsNull(Form_frmlogin.txtpass) Then
    MsgBox "enter pass", vbInformation, "adam vorood"
    Me.txtpass.SetFocus
    Me.txtpass.BackColor = vbYellow
    Exit Sub
End If
Me.txtpass.BackColor = vbWhite

If IsNull(DLookup("userName", "tbluser", "userName='" & Form_frmlogin.txtuser.Value & "' and userPass='" & Form_frmlogin.txtpass.Value & "' ")) Then
    MsgBox "nam ya ramz ghalate", vbInformation, "khata"
    Exit Sub
End If

DoCmd.OpenForm "frmmain"
DoCmd.Close acForm, "frmlogin", acSaveYes
End Sub

what should i do to show the user full name that logged in in my main menu?

[Welshgasman]

Crossposted first at https://www.access-programmers.co.uk...r-name.324056/

[orange]

Review the Similar Threads items at the bottom of this page.