Here is an article on creating an audit trail http://www.allenbrowne.com/AppAudit.html
To get the Access username use the CurrentUser function code from above article uses the Windows User name --- In [email protected], "Achi Rachimuddin" <[EMAIL PROTECTED]> wrote: > > Dear all Access Master, > > > > I have a user and password form. I want when I have input the user and > password, it will show to other forms. When we input the data into another > form the user will show in the form and when it save we will know who have > input the data. > > > > Anyone can help me what code we use or you have another sample database. > > > > Thanks > > > > Regards, > > > > Achi
