Parameter Value asking for value that is not in query

[klrich]

Anyone know what the problem could be? I have had this happen to me quite often in the past 3-4 weeks and I can’t seem to figure out why?
Example: I go to write a query (auto name is Query2) – run the query – then save the query and give it a name I chose for it. For some reason when I go to run the query after saving it I get a message that says: Enter parameter value: Query2.QTR_ONLY. I never saved it as Query2. I can click OK and then it will run the correct data. With it being a simple query I can check that it is the correct data even with the Parameter value box popping up. I have looked at the SQL and it doesn’t show where I could have a field named Query2. Is there anywhere else I should look to see where/how it is looking for Query2? This is a very basic query but I have had this happen with more complex queries as well. The only way I have found to get rid of it is to copy the SQL into a new query – give it a new name and then run it. It seems like if I save the query before running it, then I don’t have that problem.
Here is my query:
SELECT Tbl_DataSample.case_number, Tbl_DataSample.LOS, Tbl_DataSample.QTR_ONLY
FROM Tbl_DataSample;




Thanks!

[June7]

I've never noticed that but then I don't save action queries. I occasionally run one but then don't save it. I have all my action queries constructed and run in VBA code.

I think you have the solution. If you want to keep the query for future use, then save it first before running.