I am a new user Access 2016. I have started a project, for creating sales receipt. I have used a login form and got the current user name. I want to use the current user in the sales receipt form. Actually I have added the username, from the login query in my form. Now my problem, is I am not able to hold the value in the form, because the value of the field in all previous records changes to the next user login name. So all my user field in all records show the current user only.
How do I add the user name, and the username remains in the record permanently, so that I can filter records based on the user.
I am not good in codes, so kindly suggest to use with formulas and macros. Thanks