how make the nameof the user be viewed in unbounded field in a form

[musmoniem]

i had a login form
i want to view the name of the username logged in with in the navigation form
here is a sample

 

[HalloweenWeed]

[YourField] = Environ("UserName")

 

[The_Doc_Man]

HalloweenWeed's answer is correct if you have Windows-based logins (local or site domain) but not if you have your own login that doesn't go through Windows facilities.

 

[theDBguy]

Which begs the question, where are you storing the users' login information and what do you do with that information after they log in?

 

[musmoniem]

Which begs the question, where are you storing the users' login information and what do you do with that information after they log in?

i had a table had every user with its password and security level ( admin , user , viewer ) every security level had its own permission in the data base

 

[musmoniem]

HalloweenWeed's answer is correct if you have Windows-based logins (local or site domain) but not if you have your own login that doesn't go through Windows facilities.

i uploaded a sample you could see it to understand me

 

[musmoniem]

Which begs the question, where are you storing the users' login information and what do you do with that information after they log in?

i also uploaded a samlpe access data base

 

[musmoniem]

[YourField] = Environ("UserName")

please check the attatched file

 

[arnelgp]

check the code on login form and navigation form.

 

[theDBguy]

i also uploaded a samlpe access data base

Hi. Looks like Arnel beat me to it. Please let us know if you need more help. Cheers!

 

[musmoniem]

check the code on login form and navigation form.

exactly what i want brother thanks alot

 

[arnelgp]

you're always welcome brother!