default values

  • Thread starter Thread starter Glenn Causey
  • Start date Start date
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?
 
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
 
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.
 
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?
 
Back
Top