Access 2003.  I have a field in a form that should automatically show today's
date when I add a new record.  It is set up as Date$() in the table the form
is drawing from.   When I add a new record, I get #NAME? in the field until I
enter data into the form.  Then it changes the date field to today's date.  

I compared the setup to another database that is set up exactly the same
that is working correctly (it shows today's date when I add a new record).  

What is even more bizarre is that I do not have this issue on my computer,
and the rest of the staff has the issue.  We are pulling from the same
database.

Any ideas?

Heather Fabries