Security and Initials

[red91]

I have a form in which many different departments fill out information and then hand write their initials on a printed out report. I would like to set up the form so depending on who is filling out the information they can pick from a list or type their initials, or enter a password that could be later converted into their initials in a report. The trouble i'm having is that I only want the person who is filling out a particular part of the form be able to enter ONLY his or her initials and no one elses. I thought that maybe I could give each user a code to enter for their initials and then in a report convert that to their initials, but how can i hide that code from others and how do I keep others from copying the code and pasting where they want. Maybe there is a better way to do it. All I know is that I'm stumpped

 

[David R]

Are you using Access security? Perhaps you could store the UserName that they login with instead (or you can use that username to look up their initials, but what happens if two employees have the same initials?).

If you're not using Access security there are other options, but they will depend on what version of Windows you are using and whether you need to store only the last person to modify the form, all persons modifying it and what they modified, or something in between.

Please post back and someone will be able to help you.