Question Display UserName on the main form after log on

[BUDS]

He Dear,

I am new here in this thread and fairly fresh in access, hope that I can get answer to this question.

I have a simple database which tracks records of employees and already share this to my section superior Manager and Superintendents. On the log on form i had combox to select username and txtbox for password and a Main form. I want to display the fullname of a user in the main form after logging on such like i.e. Welcome John if john will log on and such other user.

But I could not get the correct method on how to do this exactly. I am trying a dummy of these but doesn't work. it looks like to look up the unbound text from the log on form.

Anybody help would much be appreciated.

Regards,

 

[rainman89]

you can do this using a dlookup and using the value from the combobox on the main form..

 

[BUDS]

Hi Dear,

Just now I've open my post since there is a problem in our internet connection. Thanks a lot I got the correct method and logic.

Again thank you so much.