Update datetime stamp on record modification

[sitaramnayak]

Hi

How can i update my datestamp feild when a record is modified. I am not using Acess form, my records are updated from an extranal application which's code is not with us. So is dere any vba or macro to do that Please help.

Exam..


Name Lastupated are two feilds on update on name lastupdated should update current time. Lastupdate values is set to default value now() for insert dates.

[June7]

You could use an UPDATE sql action. This can be a saved Access query object or VBA coded. What criteria would indicate a record has been modified?

Why not using Access form? This data is in tables in Access project?