Data Entry Initials 1

[cheyenne2002]

Is it possible to accomplish the following, I'm new so I'm not sure.

Data will be entered into my database by several people. I would like to somehow have the data entry clerk put their initials on each record they enter. Is there a way to do this. One person might enter the data for the sale and a second one for the property and a third for the purchase so each complete record might have multiple data entry clerks.

I have no idea if this is even possible. The purpose is so if someone is doing something wrong we want to be able to go to that person and explain to them what they are doing wrong and teach them the right way.

Thank you.
Sharon

 

[JerryKlmns]

cheyenne2002,

You could create a field to hold a name for every table and on every update or addition use:

CurrentUser() if you have user level security set up
or
Environ("UserName) if you run on NT/XP(/2000?)

 

[cheyenne2002]

Thank you great suggestion.

 

[PaulCooper]

control source =Environ("UserName") works in 2000 ('cos I just tried it) ~ no idea it was so easy. Thanks Paul