Name change prevents query from running

[grnzbra]

I have the following query, named "Query9" (Right, I didn't assign it a name when I first created it). Its SQL is:

SELECT LA.DL_ID, LA.UPB, LA.[FMLNo]
FROM LindActivity AS LA
UNION ALL SELECT [Q].[Deal ID],[Q].[CSUPB],[Q].[CBIID]
FROM [qry_DSRCB] as Q;

Both LindActivity and qry_DSCRB are queries, neither of which makes any reference to "Query9".

This query runs fine. However, when I change its name to PCBStack, it can't find Query9.FMLNo. If I change its name back to "Query9", it runs fine again.

Also, if I copy the SQL from Query9 and create a new query, PCBStack, and paste the SQL into it, it runs fine.

Anyone have any idea what is going on? I am using Office 2003 with Windows XP

 

[gemma-the-husky]

i've had that before. i thnik access occasionally keeps reference to the original query names. if the source queries are'nt too big, re-edit them to replace the fields producing the query9 problem, and it will go away ......

or even if they are big still do it --- its just a bit harder to find what you need to change