Enter Parameter Value

Question

I have a simple report that asks for a Value for a Parameter called "File As" - I can't find it anywhere on the report and there is no Field with that name in the Table. It should not be asking for any parameters. Tried the Database Documenter tool for help as well but no luck in finding a cause.

Thanks for any advice!

Answer 1

Have you checked the report's Record Source?

---

Daniel Pineault, 2010-2016
Microsoft MVP Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Hi Foxguy,

I am agree with the suggestion given by other community member regarding Checking the recordsource.

How you set the data for this report?

by directly setting Record source property by selecting Table, query in it?

or are you try to do this operation by code.

it is possible that you had made some changes in your record source property leads to occur this error.

if you don't understand how to check it then please post the picture of Record source of Report Here.

we will try to help you to look in to that.

also just for testing purpose you can try to create new report with same data and try to find the result of that and let us know about that.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Thanks for the quick reply. The record source is just a Table not a query

Answer 4

Hi foxguy,

did your issue solved? or still exist.

you had mentioned that you just select the table as the record source.

so it should display the record directly instead of asking parameter.

did you make any changes in table? or is your table contains the field "File As"?

you can post the table design to check.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 5

Is the report sorted and/or grouped using its internal sorting and grouping mechanism?  If so check the column names or expressions used for sorting/grouping.  

Are there any computed controls in the report?  If so check the expressions used as the ControlSource property of any such controls.

---

Ken Sheridan, Stafford, England

Answer 6

I never found the reason for the problem, but I just rebuilt the report and it works fine. Must have been corrupted or something.

Thanks for reaching out!

Answer 7

Thanks for help - I never found the root problem but I rebuilt the report and it works fine now