Parameter No Longer in Query after Table Update

[nguyeda]

Hello,

I have a lot of tables that need updating often, so I delete the old ones and re-import them then run the queries again. From time to time, I add / remove columns but in the case I removed columns that are NOT needed in the queries.

So, I ran the queries again and they run fine but it says "Enter Parameter Value" for a column that is no longer there. It's not in the SQL code either.

So where is it trying to get these columns from and how do I fix this?

Thanks! Everyone here is always helpful. I tried searching but it's so hard to find an answer for this specific question.

[rpeare]

the parameter value may be levels deep on your queries, it may not be on the specific query you're looking at. Really what you have to do is look at your query and look for any reference to any field that is no longer valid. If this is in reference to the code I gave you to import excel files and set up table definitions you may have a problem there too

[nguyeda]

Thanks, that worked!