Update Date field to current date after duping the record

[Earl Dillon]

I am at a loss as to how I should perform an automated
update of a date field after duplicating the record it is
a part of.
Example;
Lets say I have a record with all of the information on
it and I want to make another just like it and just modify
parts of it, then automatically update the date field to
display and retain the creation date.
I don't see anything in VBA that can help with this, and
I know a macro won't do this. Is there an expression I can
write in the control button to dupe the record that will
perform this action? Thank you.

 

[Myron]

Hi Earl,

if your already modifying other parts of the record why
are you having problems with the Date field. Modify it at
the same time. Use Date(), it grabs the current date.