default values

G

Glenn Causey

I have a data entry form with four rows and two fields per
row. I have a set a default of the current date in one
column. If I enter a new record, the default date is
dispalyed and is entered into the database. If I re-enter
the form at a later date, the field where the default date
should be is empty. Is there something I can do to have
the current date diplayed?
 
N

Nikos Yannacopoulos

Glenn,

Open your form in design view and display the properties window for the
control holding the date. On the Data tab of the properties window, type:
Date()
in the Default Value property. That will always default in the current day.

HTH,
Nikos
 
P

PC Datasheet

Glenn,

Go to your table and set the default value there for your field to Date(). The
current date will then automatically display in that field in all new records
throughout your database that contain that field.
 
G

Glenn

Nikos,

Thanks for responding so quickly. I have the default set
to Date() and it works for new records. If I try to add a
second record on a different day, the first record is
dislayed, but the date field for the second or third
record is empty. Any ideas?
 
Top