Date a record was created...

[CJSwed]

Hey guys.. I have a product table that is updated with new products... so I want to have a date stamp on when an item is added to this table. I created the field, selected time/ date and put the now() in.. that is all good if you manually enter in a record into the table.

The tricky part is in updating this table I will usually copy previous records from the table, copy them into a new table and rename them. (for example, if their was a vanilla ice cream in the table, I will copy that record into another, do a find and replace, name it summer watermelon for the new flavor and then paste it into the original table. When I do this, the date/ time stamp does not work since these are records being copied back into the table instead of manually entered.

Is their a micro or something that could update the date/time for records being copied into the table? Any solution you can think of?

Thanks..
Chris

 

[JoeAtWork]

Create a form and add all the fields except the date/time field. Set the form to Datasheet view.

Open the form, select the record and copy it, then select the new row line and paste.