Hi
I am trying to get user's name based on their login ID recorded in tblUserSecurity on to Navigation form after they logged in database.
example.
if Ee55er is login id and his name John Edgar the result should appear as John Edgar based on login ID verification on Navigation form.
Here is my try on Navigation Form Load event.
thanks for your help.
I am trying to get user's name based on their login ID recorded in tblUserSecurity on to Navigation form after they logged in database.
example.
if Ee55er is login id and his name John Edgar the result should appear as John Edgar based on login ID verification on Navigation form.
Here is my try on Navigation Form Load event.
Code:
Me.txtUsernameEmpNav = "frmLogin","[LoginID]" then
DLookUp("[EmpID].column(1)","[tblUserSecurity]","[LoginID]='" & "[frmLogin]![txtUsername]" & "'")
thanks for your help.