automatically put in date

[SheriTingle]

Hi again and thanks for the help. I am still having difficulties with the
opportunity to automatically include the date in my table. Per earlier
suggestions this is what I have done:
1. Created a field in my table that is called CurrentDate
2. The datatype is Date/Time
3. On my form I opened in design view, clicked on the CurrentDate control
4. Went into the properties
5. On the data tab in the Default value I tried the following things:

a. I typed =NOW() and sometimes I get an error about incorrect syntax and
sometimes nothing happens in the date field when I go back to the form view.
b. I typed NOW() and sometimes nothing happens and other times I get the
NAME? error.

I just can't seem to get the field to automatically put in the current date.

Thanks for any suggestions.

 

[Douglas J Steele]

You may want to set the default value for the field in the table, rather
than simply on your form. In that way, if you have occasion to add data
through queries, you'll still get the CurrentDate added.

Set the default to Now(), no equal sign.

As to what's happening on your form, do you have anything else in your
database named Now: a variable, a control on a form, a field in a table, a
function or anything else?

 

[xRoachx]

Some additional thoughts...

The Now() function will return the current date and time
The Date() function will return only the current date

Don't know if it will help but it's worth a shot if you only need the date.

 

[SheriTingle]

OK, so I went into the table design view and in the Date field in the
properties at the bottom I typed NOW(). Back in datasheet view, I added a new
record and nothing happens in the date field. I want the current date to
automatically be there. Nothing else in my entire database has a field or
criteria of NOW. : (

 

[xRoachx]

Did you put this in the Default Value property of the field in the table?