Display User's Full name

[tman72]

I have a function that returns the user's network name, "UserName". When my users enter the database, I have a splash form that displays their network user name on that form. I have a table "tblUsers" with fields "fldUser", "fldFN", and "fldLN"
that contains their network names, first name and last name respectively. How wold I go about displaying the User's first and last name in place of their network name on the splash form?

Thanks,

Todd

 

[jedel]

Bind you splash screen to a query that pulls the first and last name from the table based on the result of the code. Then all you have to do is place two fields on the splash screen that will show what you want.

Alternatively, you might want to look into the DLookup function

Cheers

Jedel

I'd give my right arm to be ambidextrous!

 

[tman72]

Jedel,

I used the query and that worked. Exactly what I was looking for. Thank you!

Todd