View Full Version : Creation Date Field


broomy
01-31-2001, 06:13 AM
I need to add a field for creation date to existing tables and forms. What is the best way to do this?

Is it possible to autofill this field as new rocord are created?

Broomy

pdx_man
01-31-2001, 07:39 AM
Go into the design of the form's source table and add field. Make sure datatype is date/time and default value is 'Date()'. These are listed below under 'Properties'. The default value of Date() will automatically put in the current date as new records are added.

Go into the design view of the form and select 'View', 'Field List'. This will display all of the fields for that form. You should see your new field there. Click and drag that new field onto your form. Position as desired. Good luck!