<div>
you may be forced to do this with code, but I'll keep listening to see if anyone comes up with something<br />
<br />
nzjonboy
</div>


you may be forced to do this with code, but I'll keep listening to see if anyone comes up with something

nzjonboy

<div>
You can do it on a form. &nbsp;<br />
Lets call the new field &quot;ChangeLog&quot;<br />
Go to the properties for your form, and click on the event tab<br />
Next click on one of the controls that is bound to the field that you want to track changes for.<br />
On the &quot;AfterUpdate&quot; box, select &quot;Event Procedure&quot;, then click on the &quot;...&quot; directly to the right.<br />
Paste this =&gt; &nbsp;Me![ChangeLog]=Now()<br />

</div>


You can do it on a form.  
Lets call the new field "ChangeLog"
Go to the properties for your form, and click on the event tab
Next click on one of the controls that is bound to the field that you want to track changes for.
On the "AfterUpdate" box, select "Event Procedure", then click on the "..." directly to the right.
Paste this =>  Me![ChangeLog]=Now()


<div>
Maybe I expressed myself badly. I want a date/time field that updates itself whenever the record is changed -- whatever the source of the change may be (directly, via query etc.)
</div>


Maybe I expressed myself badly. I want a date/time field that updates itself whenever the record is changed -- whatever the source of the change may be (directly, via query etc.)

<div>
I kinda thought so, thanks.
</div>


<div>
<div class="content wysiwyg-content">
Is it possible to have a field in a table that will automatically reflect the date/time that the specific records was last changed, either directly in the table or via a form? This must be updated whenever a record is changed or created.
</div>
</div>


Is it possible to have a field in a table that will automatically reflect the date/time that the specific records was last changed, either directly in the table or via a form? This must be updated whenever a record is changed or created.

Last changed date

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.