M
MikeB
I want to create a field in a table that acts almost like a timestamp.
It should record the year that the record was created. Since I have
complete control over the DB, I don't mind if the field can be
modified, I know I won't modify it. I just want access to populate it
when a new record is created/inserted into the table. Right now I
don't have a form to populate the table, but I'm thinking of creating
a form. Would this be easy (or easier) to achieve via some code in the
form?
I guess there is some OnInsert event or something like that that will
fire on an Add of a new record?
Thanks.
It should record the year that the record was created. Since I have
complete control over the DB, I don't mind if the field can be
modified, I know I won't modify it. I just want access to populate it
when a new record is created/inserted into the table. Right now I
don't have a form to populate the table, but I'm thinking of creating
a form. Would this be easy (or easier) to achieve via some code in the
form?
I guess there is some OnInsert event or something like that that will
fire on an Add of a new record?
Thanks.