last amended on

  • Thread starter Thread starter Sc2ptical
  • Start date Start date
S

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
 
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
 
Me.Last_amended = Now()
Click to expand...

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?
 
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
 
Back
Top