Keep Getting Enter Paramter Value

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top