Timestamp per record on datasheet/form

[Bob]

I'd like to populate a field on screen (datasheet like appearance with
multiple records per form) with the date/time as I any new record.

I tried [after update] with =now() and also [before update] but I
still got a blank field. What do I need to do and where?

thanks,

 

[John Vinson]

I'd like to populate a field on screen (datasheet like appearance with
multiple records per form) with the date/time as I any new record.

I tried [after update] with =now() and also [before update] but I
still got a blank field. What do I need to do and where?

thanks,

Just set the field's Default property to Now() - either in table
design view, or set the Default property of the form control.


John W. Vinson[MVP]

 

[Bob]

Just set the field's Default property to Now() - either in table
design view, or set the Default property of the form control.

John:

You mean at the Table level ?

Thanks,

 

[John Vinson]

John:

You mean at the Table level ?

Thanks,

Either at the table level, or at the form control level - either will
work. On the Form is perhaps better if this table is updated in other
ways and those ways should not set the timestamp.

John W. Vinson[MVP]

 

[Bob]

Either at the table level, or at the form control level - either will
work. On the Form is perhaps better if this table is updated in other
ways and those ways should not set the timestamp.

John W. Vinson[MVP]

Thanks.