Changing Field Value when saving

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

 

[Ketaki]

use the now() function for present date.

 

[Hugh O'Neill]

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.

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