Does the query you are using have any Parameters or Criteria set, if so Access VBA does not like them.
You may be able to get the criteria to work by setting them as Parameters.
The alternative is to build the SQL statement for the query in the VBA code.