Enter a parameter value? 1

[bobbster2000]

I have a form with a print preview button. I've deleted my queries. Whenever I click on the print preview button I get a message "Enter a parameter value". This just started happening and I've made no recent changes. Is there any way to fix this?

 

[LonnieJohnson]

Are you previewing the form or a report? What is the record source of the object you are previewing? If you are previewing the form, you may need to check the properies window for the form and see if there is information in the Order By section of the Data Tab.

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[bobbster2000]

The print preview button previews the all the info that was entered on the form in a Report called "View job". The record source is called "Zfill in" and all the info that's entered on the Form goes there. "Zfill in" is also the record source for the Report. I even get the "Enter a parameter value" message when I try open my Report without the print preview button. And it was working just fine an hour ago *sigh*

 

[LonnieJohnson]

I will assume that "Zfill in" is a table and not a query. Based on the fact that you deleted all your queries, I will assume that this report once had a query as it's record source. If all assumptions are correct, then we have a couple of things to consider...

1. Check the grouping and sorting window of the report to make sure that you do not have a control name that was in the query, that is not in the table. This could be possible because you may have changed a name in a query, or had joined more than one table in the query.

2. Secondly, check the field names in the report to be sure that they are actual names from you table. Same train of thought as above.

3. Lastly check the Order By property of the Report's property window (Data Tab) to make sure no reference to the query is stuck in there.

Hope this helps...
ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[bobbster2000]

Thanks a lot, its working again. I had a field in my report that I had to delete. You got my vote