Update Date field to current date after duping the record

  • Thread starter Thread starter Earl Dillon
  • Start date Start date
E

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.
 
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.
 
Back
Top