I designed some forms in Access 2000 and when our company converted to Office
2003, all the Date() functions in my form returned an error message (#Name?).
When I changed those fields to Now(), the dates showed up fine in the form
view. Are there links missing that I'm not aware of?

"MisJ" <(E-Mail Removed)> wrote in message
news1CE8C38-B638-40A4-B594-(E-Mail Removed)
> I designed some forms in Access 2000 and when our company converted
> to Office 2003, all the Date() functions in my form returned an error
> message (#Name?). When I changed those fields to Now(), the dates
> showed up fine in the form view. Are there links missing that I'm not
> aware of?

You most likely have a broken reference. See if the steps outlined here
help:

http://www.accessmvp.com/djsteele/Ac...nceErrors.html

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)