AutoFill Fields and save it

[semry]

I'm looking for a way to create a Userlog that track a users actions while in the application. I have a table with the following fields

UserNam
Date/Time
Action

When a user logs in, I want to fill the fields that they logged in.
When a user click to search, I want to log that they searched. And I want to do this automatically so the user doesnt' have to.

 

[rctjoe24]

Are you "logs" going to be saved in their own table?

If so you can simply run an append query when they log in;

Currentdb.execute "INSERT INTO tbl_Logs ([UserNam], [Date/Time], [Action]) SELECT 'UsersName' As Expr1, Now() As Expr2, 'Action They Performed' As Expr3", dbFailOnError

This is a current scheme I am using in one of my applications.

 

[semry]

Thank you,
It was exaclty what I wanted