Log/Track Changes Made by Users to Tables 1

[duhu]

Hi guys, first of all see my previous post:

http://www.tek-tips.com/viewthread.cfm?qid=1528369&page=1

Would someone be able to tell me how I can have the username in the "tbl_loginLOG" also entered into a field called "UserEnt" in a form called "frm_history".
This form is used to record the movement of laptops in and out of a cupboard and i would like the name of users who input entries in the history table also shown. At the moment the form has the "Information, Date & Time" fields displayed. I would like to have the username of the most recent logged on user to populate the "UserEnt" field in this form/table.

SEE:

http://www.baybie.clara.net/new.JPG

(shows the query from which frm_History is derived, to enter new information)

http://www.baybie.clara.net/Change.JPG

(shows The history form, click on "Add Note" which opens up frm_History to make a new entry)

 

[FancyPrairie]

Try this:

On the OnBeforeUpdate Event, set UseEnt to CurrentUser

 

[duhu]

set UserEnt to CurrentUser? That does not work, is there an error with your syntax perhaps?

Shot in the dark i even tried:
Me.UserEnt = Queries!qry_UserLOG!User

Didn't work too.

 

[ScriptKiddy]

Using CurrentUser()will only get you the current user that is logged into the DB(User, Admin). This link will help you if you are not using the DB in user setting. It will grab the current user logged into the computer as well as the computer name.

http://www.databasedev.co.uk/get_username_or_computername.html

 

[FancyPrairie]

Me.UserEnt = CurrentUser() 'logged on to database

or

Me.UserEnt = Environ("username") 'network logon name