"Can't open query in design mode"

Sometimes queries get to complex. Sometimes the engine can't make sense of them. A lot of hard work down the drain.

In the immediate window(^G):

?currentdb.QueryDefs("<YourCorruptedQueryName>").SQL

There it is.:p