Keep Getting Enter Paramter Value

[ChuckW]

Hi,

I have built some queries based on tables and then
created reports and then some forms that run the
reports. I have two names for our customers,
CustomerName and FullName. I originally used FullName as
a field in my Queries and Reports. I decided later that
it would be better to use CustomerName. I went back and
got rid of FullName in all of my queries and reports and
replaced them with CustomerName. The problem is that
whenever I run the report I keep getting a message that
says "Enter Parameter Value" for FullName - the field I
got rid of. I checked my SQL in my queries and the
report design and FullName no longer appears anywhere.

Any idea why I keep getting this message?

Thanks,

Chuck

 

[[MVP] S. Clark]

Check the Order By properties, sometimes the oldname get stuck in there. Or
try manually resorting the query results by clicking on the sort buttons for
the new column name.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-