Inserting Date into a separate field.

J

Jaz

I have a series of fields which are numeric fields (L1-L20 are the field
names). I would like to automatically insert date and timestamp into another
field once the number is entered in the numeric fields. The numbers are
entered over a period of time and not all together. I would like to track
the dates the fields were filled.
 
K

KARL DEWEY

If you are creating a new record each time just add the datetime field and
set the default to =Date().
If you plan on adding a date field for each of the numbered fields then you
will need to use a form with either an event or macro to setvalue for the
datetime field.
 
Top