can access use triggers?

[John]

Hello,

I am wondering if access can use triggers like sql server? I want to
be able to update a column called updated when a record is modified. Thanks
in advance.

John

 

[Cheryl Fischer]

John,

No, Access does not have triggers; it has events. To do what you want -
from a Form - you would use the BeforeUpdate event with the following code:

me!Updated = Date()

hth,