Table Question

[Juan4412]

I want to add a field called dateMofied to my table, and set it as a date/time field. What I want to do is, have it capture the date/time of when the field "Book Title" is actually modified. How can I do this with my table?

[pbaldy]

In a table, probably can't. In a form you'd use the after update event of the control containing "Book Title" and set the date field to Now().

[Juan4412]

In a table, probably can't. In a form you'd use the after update event of the control containing "Book Title" and set the date field to Now().

Grr...that's what I was afraid of.

[pbaldy]

I should have clarified that if you use a back end like SQL Server you could use a trigger, or later Access versions have data macros, which are similar (I think 2010 was the first version with data macros, but don't quote me on that).

[Juan4412]

I should have clarified that if you use a back end like SQL Server you could use a trigger, or later Access versions have data macros, which are similar (I think 2010 was the first version with data macros, but don't quote me on that).

How would I use a trigger? This is a linked SQL Server tale I want to do this action to.

[pbaldy]

As far as I know it has to be set up on the server. Do you have access to it, or is there a DBA?