If it works with tables then it should work with queries (I am assuming that the query has some records in it). Verify that the name of the query is a valid VBA variable name and if it is not, elclose it within square brackets.