Tupacmoche
Registered User.
- Local time
- Today, 04:46
- Joined
- Apr 28, 2008
- Messages
- 291
Hi Table Masters,
I want to add an audit feature to a table. I was thinking of putting it in the after update event code of the field. I have put code there to turn a labels visibility to on when that filed Not IsNull. This is the code:
If Not IsNull(Me.txtWriter.Value) Then
Me.TxtW.Visible = True
Else
Me.TxtW.Visible = False
End If
Now, I want to add code that will update a column called AuditWrite with a time stamp something like this: Update AuditWriter = Now() but only for the current record. How do, I limit it to the current row?
I want to add an audit feature to a table. I was thinking of putting it in the after update event code of the field. I have put code there to turn a labels visibility to on when that filed Not IsNull. This is the code:
If Not IsNull(Me.txtWriter.Value) Then
Me.TxtW.Visible = True
Else
Me.TxtW.Visible = False
End If
Now, I want to add code that will update a column called AuditWrite with a time stamp something like this: Update AuditWriter = Now() but only for the current record. How do, I limit it to the current row?