auto add a datetime stamp record

[ave]

Is there a way to setup a field so that it automatically time stamps a field

I create a field with datetime type and set the default to NOW().

If I create a new record directly in the db this field get filled out.
However if the record is created through a FORM (actually 3rd party software
that uses access as a backend) it doesnt get filled out.

Any idea why?

thx in advance

 

[Nikos Yannacopoulos]

Ave,

You should put the Now() function in the default value property of the
control on your form which is bound to the timestamp field.

HTH,
Nikos

 

[ave]

Yes, unfortunately the form is 3rd party and i dont have access to it. It
not done in Access either.

It only has access backend.

I can add fields to the access tables, but have no control over the
interface.

 

[Nikos Yannacopoulos]

Ave,

AFAIK the answer is you can't do it under the circumstances; it has to be
done in the FE.

Nikos