MSAccessRookie - Thank you, you've solved an issue that's been plaguing me for a while. It doesn't solve the why but at least it's manageable and for that I'm very grateful.
With this said, I noticed I was able to fix the same issue by simply copying the SQL, deleting it, pasting and then...