auto update time field

[bangsmic]

I am duplicating a previous record and editing that record while maintaining the integrity of the original data. The duplication is done through the "duplicate" command button and I can distinguish between the original and edited records by means of an auto # field.

When I "duplicate" the record, how can I automatically update the "time" field based upon the system time so the user doesn't have to?

 

[Bastien]

me.fieldname.value=now() Bastien

There are many ways to skin this cat,
but it still tastes like chicken