User login difficulties

[Raveen1609]

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

[isladogs]

Data is stored in tables not forms. So you need to add a username field to your sales table and use a bound control for that field on your form.
Use a function to get the username from the login form and to populate that field in the table.

[Raveen1609]

Data is stored in tables not forms. So you need to add a username field to your sales table and use a bound control for that field on your form.
Use a function to get the username from the login form and to populate that field in the table.

Thank you very much for your response. ok. I added a username field in the main sales table.

Now, I am not very sure, what kind of function to use, to bring the current username, to the sales table.

[Gicu]

on the form you can set the default value of the text box bound to the new field to Environ("username") .

Cheers,

[isladogs]

If the user logs in with their Windows username then you could use e.g. Environ("UserName")

Otherwise, you could use a global variable strUserName (or a TempVar)
Set this equal to the username entered in a textbox on your login form so the value is stored whilst the user remains logged in

When the user opens the sales form, populate that field with the saved user name

[Raveen1609]

I set a default value in a txtbox in the form. Done.
thanks and Merry Christmas

[Raveen1609]

Hi,

My access 2016, database with FE and BE. I copied FE in another computer- connected LAN. When I operate the FE in the network computer, I am not able to get the images in the form. My images folder is in the 1st computer. Whereas the images appear in the 1st computer. I am missing some links. Thanks

[Raveen1609]

I found the correct linking of the file path. solved. Thanks