Default Values

[Dion]

When a user logs in to my application, he/she enters a
username and password which is validated to the employee
information in the tblEmployees table. When a user is
cleared to continue into the application, they are taken
to a Main Menu. One of the options in the main menu is to
log calls. In the Log Calls form, there is a field
called "Call Received By". (the form is based on a "Call
Log Entries" table) I want to set this value for each
call a user logs to be his/her username that they used to
log into the application. Any ideas on how to accomplish
this? Any help is appreciated.

 

[Guest]

You can do it a couple of ways

When a user logs in, the database can open a hidden form that holds the UserID so it can be referenced other places (like logging calls) o

When a user logs in, the database can store their UserID as a global variable that can be referenced anywhere in the databas

And I'm sure there are more ways, too, but these are the ones that come to mind. I usually use global variables

Hope this helps

Howard Brod


----- Dion wrote: ----

When a user logs in to my application, he/she enters a
username and password which is validated to the employee
information in the tblEmployees table. When a user is
cleared to continue into the application, they are taken
to a Main Menu. One of the options in the main menu is to
log calls. In the Log Calls form, there is a field
called "Call Received By". (the form is based on a "Call
Log Entries" table) I want to set this value for each
call a user logs to be his/her username that they used to
log into the application. Any ideas on how to accomplish
this? Any help is appreciated