last amended on

[Sc2ptical]

Hi there,

Is it possible that when someone change a record via a form that you can
see on what date and time it happend. For example you create a field in a
table as "Last amended on:" and that this field keeps a track when a record
is updated and you can show this also on a form? Thanks for the help.

Sc2ptical

 

[Nikos Yannacopoulos]

Yes! Add a date/time field to the table design. Add a textbox on your form,
name it, say, Last_amended, and set its ControlSource property to that
field.
Finally, use the form's Before Update event to run this line of code:

Me.Last_amended = Now()

HTH,
Nikos

 

[sc2ptical]

Me.Last_amended = Now()

Thanks Nikos for your help but I cannot let it work. I tried the following
steps.As you said I created a field in a table then created a texbox,
linked the textbox with the date/time field. Put the code line in the
before update event but so far not working. I have no idea what I'm doing
wrong. You have any idea what I'm maybe doing wrong?

 

[Nikos Yannacopoulos]

Any chance you put the code in the Before Update event of the textbox
itself, rather than the form's one? It has to be the form, the textbox's BU
event won't fire unless you manually change it, which is what you won't be
doing...

HTH,
Nikos