Auto Insert Date and Time

[Zonie32]

I have a form where I want to add a date/time stamp each time someone goes into it and makes changes to any of the text boxes.

One record could be updated several times a day so I want the date/time to change whenever any of the users update it. I also need to have a textbox that captures the user name as well so we can track who is changing the data and on what date and time.

How can this be accomplished? I have a textbox for =currentuser and that seems to work ok. Not sure on the date/time stamp. Help is appreciated.

 

[PHV]

In the BeforeUpdate event procedure of the form:
Me![TimeStamp control] = Now()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mygmat123]

I would create a table called "audit". with "audit_id"(auto-number) as primary key, "Field_name", "Old_value", "New_value".

Then make an run an "insert" SQL command to the table.

It will give you a nice audit trail.