built in date function 1

[jxxnorth]

After switching from win98 to xp, the built in Date() function seems to not be working. As an example, I use Date() as the control source for a text box on a form. After changing to xp, the text box displays #Name rather than today's date. Also, =Date() is used in an update query. Now when I run the query, I get an error dialog that says "Undefined function 'Date' in expression."

Could someone suggest a fix for this problem?

 

[Lightning]

Check for missing references/object libraries.

Open any VBA code module and go to Tools|References.
Check to see if any libraries are marked "MISSING"

HTH
Lightning