Date function failing

[Bill]

I have an Access ADP application that connects to a SQL Server database. One field on the form, an unbound field, has as its default value the current date. In the data tab, default value, I have the following, "=Date()"

On most machines the field display's the current date as the default value. However, on several other machines I get the unknown value (#?name or whatever it defaults to)

Any ideas

Bill

 

[Van T. Dinh]

Likely to be the References Error.

See Douglas J. Steele's article:

<http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html>

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
I have an Access ADP application that connects to a SQL

Server database. One field on the form, an unbound field,
has as its default value the current date. In the data
tab, default value, I have the following, "=Date()".

On most machines the field display's the current date as

the default value. However, on several other machines I
get the unknown value (#?name or whatever it defaults to).