Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter value wont go away

Status
Not open for further replies.

jeffmoore

Programmer
Aug 29, 2003
301
US
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.

Hope some of that helps.
 
thats what it was ... a control that was refering to it ... I hate it when that happens!!!
thanks
Jeff
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top