adding a date

[Simon]

Every time i enter a new customer i would like to keep a recored of the
date i entered that customers.

Whats the best way of doing this when i enter a new customer in the
customer form. The only thing i need to make sure it does it when i
changes any detaisl of the cusomer form it does not changethe date


Thanks

simon

 

[Guest]

Add a DateTime field in your table named RecordDate with default of =Now()

 

[fredg]

Every time i enter a new customer i would like to keep a recored of the
date i entered that customers.

Whats the best way of doing this when i enter a new customer in the
customer form. The only thing i need to make sure it does it when i
changes any detaisl of the cusomer form it does not changethe date

Thanks

simon

Code the Form's BeforeUpdate event:
If Me.NewRecord and IsNull([DateField]) Then
[DateField] = Date
End If

If you want the time as well as the date then use:
[DateField] = Now()