I have a database with table name tbl_login.
Fields in the table include: FirstName, LastName, UserName & Password.
Am able to login to open my main form successfully.
Now my issue is, I will like to let the users First name be displayed when logged in.
Eg. if Samson is the FirstName and Sam is the UserName, when I log in with Sam, Samson should be displayed on my main form as the current active user.
Any help with this will be greatly appreciated.
Thank you