Date data entered 1

[Stephenlyn]

Hi All

I have a database and I need to know when the each data record was entered.

Any ideas....

cheers

Steve

 

[RoyVidar]

In the default value property of the field, try entering:

=Now()
or
=Date()

- now will give a timestampe, date will give the current date.

Should you also be interested in when a record is updated/changed, It would probably be best using the before update event of a form where this data is changed, something like this

[tt]me!txtUpdatedDate.value = now ' or
me!txtUpdatedDate.value = date[/tt]

- won't need (parens) in code

Roy-Vidar

 

[Stephenlyn]

Thanks Roy-Vidar

The form update event works a treat.

cheers