Well, generally speaking you would create a table to hold the modified data. You might have 3 fields
FieldName......DateModified......txtOldValue
then in a sub, you could have this code.
CODE
Sub captureChange()
Dim rst As DAO.Recordset
Dim fldName As String
Dim ctl As Control
Set rst = CurrentDb.OpenRecordset("tblModified", dbOpenDynaset)
If Me.NewRecord Then
Exit Sub
End If
If Me.Dirty Then
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
rst.AddNew
rst!FieldName = ctl.Name
rst!DateMod = Now()
rst!txtOldValue = ctl.OldValue
rst.Update
End If
Next
End If
End Sub
Then you would call this code from the AfterUpdate event for each control you want to keep track of changes in.
Paul