Last Modification Date on a field

[Fie]

I need to record the date of last modification on a field.

How can I do this ?

Access 2000

Fie

 

[Arvin Meyer]

I use the Before Update event to update the field used for the timestamp
(aircode):

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

 

[Fie]

So var I've figured it out, however it doesn't save it to table, and doesn't
show it on the form when I refresh the form.

Fie

 

[Arvin Meyer]

You need to add the timestamp field to the table (datatype date/time) and a
textbox to the form bound to that field. In this case I named that textbox
txtTimeStamp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Fie]

This doesn't work, any ideas ??

Fie

I use the Before Update event to update the field used for the timestamp
(aircode):

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

 

[Van T. Dinh]

I hope you are aware that this only works if you perform edit on a Form???