User ID without Access Security--Now What?? 1

[JonWolgamuth]

I used the sample code to add a Module called "GetUserName" which culls the user's ID from the network logon. (

http://support.microsoft.com/support/kb/articles/Q161/3/94.asp?LN=EN-US&SD=gn&FR=0)

(I didn't want to implement MS Access Security.)

Anyway, I have a table with the user's First Names, Last Names, and Network Logon ID's. How do I get from here, to a place where everytime a user enters a record on a form, it looks up their userID, and automatically enters their names as processor to the table?

I'm relatively new to this, so any help will be appreciated!

Thanks!

Jon Wolgamuth

 

[DaveShmave]

Hi Jon,

Try this:

http://odyssey.apana.org.au/~abrowne/AppAudit.html

It's a little involved but it definitely works.

HTH

Dave