UserName

[Dion]

I am building a Call Tracking program. I have a login
screen where a user types a username and a password. This
is compared to an Employee table's username and password
fields. If they match they are able to get into the
program, if not, the program closes. After the user is
allowed to open the database, he/she can enter data about
received calls in an "Enter Calls" form. One field in the
form is "Call Received By". I can make it so the default
value is the Windows login, but I want the username from
the person who logged into the program. Does anyone know
of a way to do this?

 

[Gerald Stanley]

Try storing the userName into a global string variable once it
has been validated.

Hope That Helps
Gerald Stanley MCSD

 

[Dion]

How would I do that?

-----Original Message-----
Try storing the userName into a global string variable once it
has been validated.

Hope That Helps
Gerald Stanley MCSD
.

 

[Jim/Chris]

The user logged into the app is CurrentUser()

Jim

 

[Gerald Stanley]

To define a global variable, open a new module and type in
Public gstrUserName as String

In the form that the user enters the username and password,
when the inout has been validated, populate the global
variable e.g.
gstrUserName = {yourtextbox}.Value

Hope That Helps
Gerald Stanley MCSD