Access 2007 date function not working

[Mark K]

I had a database in Access 2003 that I imported into 2007 and all works well
except the date function in Reports. I have tried to go into reports and
repair by adding a date field, but when I try to open the report and error
box comes up asks for update parameter value for the date. The currrent date
will not display in my reports, just (#name?) is in the date field. You would
think trying to put the current date in a report would be easy.

 

[KARL DEWEY]

Use this ---
=Date()

 

[Mark K]

That's the problem that function does not work in my report-I even tried the
button that inserts the date and still the error persists. I also tried to
make a new report and just insert the date and no luck.

 

[Mark K]

I created a new database and the date function works-not sure why it doesn't
work in the other database.
Thanks, Mark