Get Rid of "Enter Parameter Value"

[ScS]

I had to delete an old table with faulty information and
then create a new table with new information. With the
old table, I could access my Reports with no problem.
Now, whenever i go to click on them, they ask me to enter
in parameter value. how can I get rid of that message?
Thanks.

scs

 

[RobFMS]

Some where in your report source or controls, you are referring to a field
from your old table structure.

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Ted Allen]

If the report is asking you to enter a parameter value,
it is probably because it can't find one or more field
names in the recordsource that match fields bound to
controls in the report.

I would check the report's record source to make sure it
is set to your new table name. Or, if it is specifying a
query, open that query in design mode to see if you need
to replace the old table with the new one in the query
design.

If neither of those are the problem, look at the controls
in the report and see if they match the field names in
the reports record source (table or query) based on the
new table.

One last idea, if the report is based on a query, the
query could include a parameter prompt. If so, you could
remove it if it is not needed. But, if this were the
case it would have also happened before you changed the
tables.

-Ted Allen