I was using placeholders, ta. I tried the trace thing and got a lot more info but none of it useful. Having now gone into Access I've seen that's all it gives for error messages anyway! Thanks for the suggestion though. :-)