I made a macro that records the date and time that each record was last modified when data is entered using a form. I also want access to record keep the original date and time when the record was created. Any ideas on how to do this?
I made a macro that records the date and time that each record was last modified when data is entered using a form. I also want access to record keep the original date and time when the record was created. Any ideas on how to do this?
Make the default value of a "DateTimeAdded" field Now().
You will need an additional field in your table. You would set the default value for that field to the current date/time using the now() function. You would not include a control on any of your forms that are bound to that field.
oops, I see Paul beat me again.
Thank you both pbaldy and jzwp11!
No problemo!