This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a report with a crosstab query for the Record Source. Within the crosstab query, I originally included a field (F1_GRPORDR) that I was using to order the results. However, I decided to use another field and deleted that field from the query. Yet now when the report is being called to open, I get the "Enter Parameter Value". Choosing okay the report opens yet not in the order as set in the query. I searched for F1_GRPORDR and it is not in any query, table, event, group/sort, or anything else I can think of. I compacted and repaired the database yet the "Enter Parameter Value" still appears. I am going nuts here! Any help is much appreciated. Thanks.
PS If I run the query alone, the results appear as designed.
PPS I ran deep search in VTOOLS and it says this parameter is a control source in the report yet I cannot find it.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Inspect the report in design view. It could be the Order By property, or it could be a grouping level or sort that was created.
Tom,
I missed something in the Group/Sort for which I had two and the second was the parameter in question. So when I removed the parameter from the query the Group/Sort only showed 'expression'. So when I deleted that it worked. Thanks so much!
Tom,
I checked that and there is no Order By for the Report. Order By On Load is Yes yet makes no different when set to No. There is a Group/Sort yet that is for a different parameter.