access thread: Re; Track who updated a record.
Someone asked about this and I got clumsy and deleted the
letter from my inbox then from the trash. I use the following
for a "Before Update" procedure for the form.
Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo ERR_Form_BeforeUpdate
Forms!Admin_Inv_F000100!Last_Transaction_Date = Date$
Forms!Admin_Inv_F000100!Last_Transaction_User = get_username()
"Last_Transaction_Date" and "Last_Transaction_User" are fields
defined in the tables.
To the best of my knowledge Access has nothing built in to do this.