Macro Error Message

[dmugan]

There had been no error for the last year, now suddenly today I receive the error - Undefined function 'date' in expression for the following:


UPDATE Table1 SET Table1.[Days in House] =DATE()-[Mod Received Date] WHERE IsNull([Mod Resolved Date]);

DATE() is simply the current date and I don't get it!

Any advice is greatly appreciated

 

[dmugan]

Never Mind, Found Answer Below

A missing reference is causing the problem. Go to that user's computer, open a form in design view and click the code button. Then Tools--->References, a list should appear. If any are marked missing, make a note of the name and uncheck those with Missing. Then check the boxes by the correct ones.