Default date does not save to the record

  • Thread starter Thread starter Ken Cobler
  • Start date Start date
K

Ken Cobler

I have a form based on a query. The query combines the names of
organizations with their grant request(s) (the "many" side of a 1 to many).

Since we are in the current 2008 grant year, I want the grant entry to
default to 2008. I tried placing a default value of year(date()) on the
table field default value, and on the form's field default. I have even
written out "2008" as the hard-coded default value, but I still get the
following problem:

In any case, when I go to the end of my records, I can see the year field do
the default to 2008, as it suppose to do. But as soon as I start to create
the record, I get an error message "Field cannot be updated". I'm wondering
why my entry is not working. Any suggestions? thanks!
 
What data type is this field? If it is a Date/Time field, 2008 is not a
valid date.

What is the name of this field? If it is a Number field called Year, make
sure Name AutoCorrect is turned off, and change it to (say) GrantYear. (If
it is a Text field, change it to a Number field.)

If that doesn't solve it, does the problem only occur if you enter records
in the query? Or does it occur in the table also?

Does the problem disappear if you (temporarily) remove the default value
from the field?
 
Back
Top