Default Value Expression won't work

[News]

I am very much the newbi at this so pardon my ignorance.

I am creating a table and would like the Detail Due field (Data Type
Date/Time) to be calculated from the Order Received field (Data Type
Date/Time). I am using the Expression Builder with the following in the
Default Value section


=DateAdd("d",+7,[Order Received])


When I try to save I then get an error

The database engine does not recognize either the field 'Order Received' in
a validation expression, or the default value in the table 'Table1'.


Any help would be much appreciated

 

[Arvin Meyer [MVP]]

You can use that expression in the default value property in a form, not in
a table. Tables don't run code and can't relate fields in expressions like
in a server database. The expression:

=DateAdd("d",7,Date())

would work because it doesn't refer to another field