2007 Parameter Problem

G

GL

I am having a problem in 2007 when creating a report. For example if I
create a report based on a query, and the report first references two
different fields Last Name and First Name in separate columns. Then I decide
to concatenate LastName and FirstName into one new field called Member (I do
this in the query). I then change the report field to reference Member in
the query. I've done this thousands of times in the old version and never
had a problem. Now when I run the report it asks me to enter a parameter for
FirstName and LastName even though they are not referenced anywhere in the
report!! I normally just click through the asking of the First and Last Name
and the report runs fine, shows the member names as it should. I checked
sorting to see if they were referenced there but they are not. Is there
somewhere else in the background that still looks for the separate fields
that I'm not thinking of. I even checked to see if there was a count being
done, can't find anything. It is just such an annoyance to have to either
recreate from scratch using MemberName (if I recreate the report based on the
modified query it works fine or deal with clicking through the parameters!)
Please help if you can!! Thanks!!!
 
A

Allen Browne

If you changed the name of the field in the source query:

a) Change the Name property of the text box on the report (as well as its
Control Source.)

b) Look in the Sorting And Grouping box.

c) Look in the properties of the report: Filter, OrderBy.

d) Look for any other text box that still refers to the old field names.

e) If the query itself asks for these parameters, look in its Filter and
OrderBy properties.

f) Make sure Name AutoCorrect is turned off. The compact/repair. Suggested
steps:
http://allenbrowne.com/recover.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top