Had the same problem.
Field properties had the default value as DATE()
I removed the default value from the properties and assigned the DATE in the Form_open().
It solved the problem
P.S.: Another field had date assigned both in Default value in Field properties and in Form_open() and it did not have the problem. So the Default Value in Field properties seems to be the problem for me.
this sounds like a missing reference. Open a vba module and click tools/references. see if any references are flagged up a missing.
it may well be Visual Basic for applications
Whoops just noticed you'd checked this earlier... please ignore the above point
Do you have more than one version of Access on your computer?
If you install more than one version of Access under Windows Vista, you’ll run into trouble. It’s a Registry problem: Regardless of which version you open, Access uses the library registered last. Interestingly, Access 2007 will run, after a quick installation fix.
There are numerous and complicated workarounds, but the best solution is to avoid installing multiple versions of Access on Vista. Better yet, just avoid Vista altogether.