Query which reverts to a previous (deleted!) version when activate

[Chris Green]

I have a query defined to provide a list of total payts in a year for a group
of customers. Every time I open the form for which the query is the data
source it reverts to an earlier, incomplete version of the query and stays
like that. I now have a pile of redundant queries stacking up named with
variations on 'microsoft is crap' - any ideas how it can keep reverting on
its own?

 

[Marshall Barton]

I have a query defined to provide a list of total payts in a year for a group
of customers. Every time I open the form for which the query is the data
source it reverts to an earlier, incomplete version of the query and stays
like that. I now have a pile of redundant queries stacking up named with
variations on 'microsoft is crap' - any ideas how it can keep reverting on
its own?

Shot in the dark. What is the query name in the form's
RecordSource property? The reason I ask is that the
NameAutoCorrect feature might be changing the name in some
places when you rename an item in another place. You should
double check that Track Name AutoCorrect is turned off
(Tools - Options - General).

If that's not the problem, my only other wild guess ia some
form of corruption.

 

[Chris Green]

Thanks for the suggestion Marsh, but I very dumbly forgot a lump of query
text in the VBA code so that's 'Chris is crap' rather than 'Microsoft is
crap', apologies.