JonWolgamuth
Technical User
I have a database where we keep track of incoming mail--who receives it and who completes it.
For several month's, users were entering their own names to identify their work via a combo box. I have set up a new form where the name field is now populated by their user ID from Windows login. (Ie. TJWWLC is my login ID) Now the record for employee name has some last names, and some login IDs.
I have added the user's login ID to the Employee's name table, so they all correspond.
I'm assuming I can do a DLookup function somewhere (code? criteria on a query?) to make the form show the current users name rather than their login ID.
Anyone?
Thanks in advance!
For several month's, users were entering their own names to identify their work via a combo box. I have set up a new form where the name field is now populated by their user ID from Windows login. (Ie. TJWWLC is my login ID) Now the record for employee name has some last names, and some login IDs.
I have added the user's login ID to the Employee's name table, so they all correspond.
I'm assuming I can do a DLookup function somewhere (code? criteria on a query?) to make the form show the current users name rather than their login ID.
Anyone?
Thanks in advance!