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

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

"Simon" wrote:

> 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
>
>

On 13 Oct 2006 14:54:50 -0700, Simon wrote:

> 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()
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail