'Updated Last' field

[AmandaBurlingham]

I have now created a logon page where users choose their name and enter a password to get on database. the details:

SELECT tblEmployees.[lngEmpID], [tblEmployees].[strEmpName] FROM tblEmployees ORDER BY [strEmpName];

I have many forms with an 'updated by' field (i need to know the last time info has been changed) How do i set these boxes to be completed each time data changes - based on who has logged in? (I do not want to use the computer user name!) Do i need just a text box in the form or am i right actually having a field in the underlying table calld last updated by?
EG once data has changed on frmPersonal details i have a box called Last Updated: i want it to change to Burlingham, Amanda - 02/09/09 - 11:15PM

I think this will be so easy but being a complete novice.....

 

[ajetrumpet]

I have now created a logon page where users choose their name and enter a password to get on database. the details:

SELECT tblEmployees.[lngEmpID], [tblEmployees].[strEmpName] FROM tblEmployees ORDER BY [strEmpName];

I have many forms with an 'updated by' field (i need to know the last time info has been changed) How do i set these boxes to be completed each time data changes - based on who has logged in? (I do not want to use the computer user name!) Do i need just a text box in the form or am i right actually having a field in the underlying table calld last updated by?
EG once data has changed on frmPersonal details i have a box called Last Updated: i want it to change to Burlingham, Amanda - 02/09/09 - 11:15PM

I think this will be so easy but being a complete novice.....

amanda,

try a simple timestamp on the form's dirty event. that's the way i have done it in the past. do you know how to do that?

also, how do you identify the current user? do you have a table that holds it, or do you put it in a var? that info will tell you how to pull it and put in on the timestamp when the dirty event(s) come about...