I HAD a prameter value in a query. I have deleted it form the query, deleted the query, builta new query and attached it to my report. rebooted the @#$%$# machine .... The damn thing still asks me for the parameter when I run the report
TIA
JEFF
You should make sure that no controls (text boxes, combo boxes, etc.) still reference that control in your report. This doesn't have mean that their Control Source references that field you deleted, but it could be part of an expression somewhere like "= Field1 * deletedField" or something like that.
I assume you've done this, but make sure your query will run by itself before basing the report off of it by viewing it in Datasheet View.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.