Unknown - "Enter Parameter Value"

[mdo]

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!

 

[Rich]

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

 

[mdo]

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.

 

[Rich]

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.

 

[mdo]

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.