This one is driving me mad! The database I'm working with is meant to download data into Publisher to create posters, I have one version that works and one that gives me the Run-time error. The query works, the code looks right, and just to make life interesting, I created a new copy of the database importing all of the tables, queries, forms, posters and macros from the version that works, and I still get the same error message! I know this isn't much info, but if anyone else has come across anything similar, at least I won't feel like I'm going completely mad!!