Enter parameter value prompt in ACCESS 2007 Report but not in 2003.
Posted on 2009-04-17
I have a strange behaviour that wasn't occuring a week ago. I have a database with a report that now gives me an "Enter Parameter Value" prompt for the field "ID1" which is the primary key that the query for the report is based on. The exact same database doesn't have this prompt on another machine that is running ACCESS 2003, but does have the same issue on another machine with ACCESS 2007. I actually copied the file to the other computer to make sure they were the same.
The second page of the report is linked as a child to the main form using ID1 from the main form and ID4 from the child.
Any ideas why this is happening in 2007 and not in 2003, and how can I make it stop?
Any ideas why this would change and what is causing it?
This may not be a cause, but I recently loaded Virtual studio 2005 on the two machines where the problem is happening.