none
Enter Parameter Value RRS feed

  • 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!

    Friday, October 28, 2016 12:10 AM

All replies

  • 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

    Friday, October 28, 2016 1:19 AM
  • 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 MSDNFSF@microsoft.com.

    Friday, October 28, 2016 2:07 AM
    Moderator
  • Thanks for the quick reply. The record source is just a Table not a query
    Friday, October 28, 2016 7:24 PM
  • 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 MSDNFSF@microsoft.com.

    Monday, October 31, 2016 2:42 AM
    Moderator
  • 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

    Monday, October 31, 2016 11:18 AM
  • 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!

    Monday, October 31, 2016 5:24 PM
  • Thanks for help - I never found the root problem but I rebuilt the report and it works fine now
    Monday, October 31, 2016 5:25 PM