Can't get date to save in table..........

[Tony]

I created a Ship Date field in a Table, created form using the ship date
field, wanted the field to display current date using date (), but the date
does not save back to the table.

Thanks for the help

 

[Jeanette Cunningham]

Tony,
If you always want the ShipDate field to show the current date and time, you
can set this in the table as the default for that field.
A good idea, as if you ever append any records, access will put in the
current date and time for you.

Usually if you set the default value of a date/time text box for a form,
that data is saved back to the table.
How are you setting the default value in the form?

Jeanette Cunningham

 

[Rick Brandt]

I created a Ship Date field in a Table, created form using the ship
date field, wanted the field to display current date using date (),
but the date does not save back to the table.

Thanks for the help

=Date() needs to be in teh DefaultValue property. Sound slike you used it
in the ControlSource. That is where you should have the name of your field.

 

[Tony]

In the table the Data Type is Date/Time

The format of the Text Box is General Date........

I can get todays date to show up in the Form when I click on it but it does
not want to save the date field to the table.

This is got to be easy but I am missing something.

Thanks for your help and patience

 

[Tony]

Should that be in the table or the Form?

Thanks Rick

 

[Jeanette Cunningham]

It would be the same for either the table or form.
As mentioned before, if you do it in the table, you don't have to worry
about doing it in any forms that are based on that table.

Jeanette Cunningham

 

[Tony]

Thanks for the help, I put it in the table and everything works great.
Thanks for the help.

Tony