Changing Field Value when saving

  • Thread starter Thread starter Rob Sorfleet
  • Start date Start date
R

Rob Sorfleet

I have just started using access for creating screens to
use with databases. I have a field that holds a date value
which I would like to update with present day's date. The
field isn't part of the form, but I would like it to be
automaticaly updated when the save button is clicked on
the form. I have searched through the help file but to no
avail. Any help would be of great value to me.
 
Rob said:
I have just started using access for creating screens to
use with databases. I have a field that holds a date value
which I would like to update with present day's date. The
field isn't part of the form, but I would like it to be
automaticaly updated when the save button is clicked on
the form. I have searched through the help file but to no
avail. Any help would be of great value to me.
Click to expand...


In the Default Value property of the Field in the Table design, put:

=Now()

This will put the current date/time into that Field whenever you create
a new record in that Table.

hth

Hugh
 
Back
Top