Yeah, it's a good idea to use environment variables to capture the identity of people making changes. I use these default values in tables where users will be creating new records, then I just don't show the fields and they are updated with the default values.
sUser = Environ("UserName")
sComp = Environ("ComputerName")
dTime = Now()
HTH
mmcdonal
|