Hi!

I used a field called Date by mistake in my database. Some of the users are getting #NAME? when I put Date() as the default value so I changed it to NewDate. Now I'm getting "Enter parameter value - Date" when I run the reports. I have changed all my queries and grouping in all the reports to point to NewDate. I changed the fields from Date to NewDate. Why is this happening. The Date no longer exist anywhere, but it still keeps asking for this value. please help!

Thanks!

Users were getting #Name errors because of a missing reference problem, search here for solutions

Hi Rich,

The #NAME? is not the issue. Only a couple of user out of 23 were getting it and I think it's because I used Date as a field and this is a reserve word in Access. The problem I'm getting now is the "Enter parameter value - Date" that keeps popping up eventhough I'm not using Date as a field anymorel. I changed it to NewDate (see my note before - thanks). Please help.

Thanks.

You still have a reference to the field Date somewhere in a query, within the reports sorting grouping etc, again though the #Name problem was definitely a missing reference problem.

I ran all my queries and it's all ok. I double checked my grouping in the report and it's also ok. There is no field called Date anywhere. Only when I run the report that it is being asked to enter the parameter value. I don't know where this is coming from? Help.