Update By field?

[Guest]

Is there any way I can put a field in a table that records who the last
person was that touched a record?

Thanks.

 

[Rick B]

Yes. Do a search for "timestamp" or "audit trail". This is addressed in
here pretty often. You should find previous posts that point out how to do
this, and maybe even some links to sample databases and code.

You should always search the newsgroups before posting a new thread.

Hope that helps,

Rick B

 

[Arvin Meyer]

Is there any way I can put a field in a table that records who the last
person was that touched a record?

Use the Before Update event of the form, something like:

Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtLastUpdated = Now
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Lynn Trapp]

If you implement user level security, then you can use the following code to
insert the user name of the last person to update a record.

Sub Form_BeforeUpdate(Cancel As Integer)
Me.txtLastUpdatedBy = CurrentUser()
End Sub