How to record user name upon record has been added or edited in a particular field?

[Jagadeshwar Rao]

Hai friends,

have a great day

i am using ms access 2003 in which i created a file with login username and password form(with some simple code not OS login username and password) and made the file such that it will open only if they enter correct username and password in that form every time the file is opened.

Now i want to record the name of the login person in a particular field of table or form whenever they add a new record or edit existing record.

please anyone help me in solving this problem which will be very much helpful for me.

for any details please send me an email to ** Edit - email removed as per site rules **

Thank you advance for helping.

[NeoPa]

First you need to store the data entered somewhere. This would most easily be done in a global variable in a standard module of your project.

When you have this available it is possible to add this information into a query by updating the SQL in your code.