HOW TO INSERT DATE AUTOMATICALLY

  • Thread starter Thread starter Guest
  • Start date Start date
Thanks John, I followed your instructions exactly and it keeps changing the
date to the current date, it is not holding the date I created the record.
All records have today's date.
Click to expand...

You posted elsethread that the textbox has properties

in the form section the requested info as follows:
Name: Invoice Date
Control Source:-Date()
Default Value:Date()

The control source IS WRONG.

The Control Source property determines what will be displayed.

You have it set to Date(), so it will display today's date, regardless
of any field that is stored in your table.

Change the Control Source property to

[Invoice Date]

and you should be back in business.

John W. Vinson[MVP]
 
John said:
I misunderstood your issue; you're quite correct, of course, that the
stored date field can be manually edited. However, unless someone
takes deliberate action to change it, Access won't change it on its
Click to expand...

Think about it the other way around: if there is no mechanism to change
the date (apart from the Admin table owner) then it cannot be changed
by Access, an Access user, an Excel user, an ADO user, etc. This is,
after all, the database/tables group and not the frontend/forms group :)
 
Back
Top