Copying a query issue

[liamrowan]

I have a qry named qryAllocList-FINAL. I right clicked on it, copied, and pasted as qryAllocList-FINAL+SUPPLEMENTAL. Immediately when I open up the copied version I get an "Enter Parameter Value" pop up with the reference "qryAllocList-FINAL.DistrictCode" above the window in which to enter a value. I click on OK and all the data shows up, but I don't know why an exact copy of the file isn't functioning like the original.

There is no field in the original or copied query which specifies data to come from the original qry, such as: [qryAllocList-FINAL].[DistrictCode].

I tried Compact and Repair, but no luck there, either. I don't know where to look to prevent this window from popping up.

Thanks for ideas.

Wm

 

[boblarson]

Check (in SQL view) to see if the SQL strings are exactly the same. Perhaps some corruption is occuring in your database. You might try importing everything into a brand new, mdb or accdb shell and see if that helps.

 

[boblarson]

Oh, and make sure NAME AUTO CORRECT (also known as auto corrupt) is turned off.

 

[gemma-the-husky]

if you copy the SQL into a new query, it should fix it.