Error when connecting an Access query to an excel sheet -expression in query prevents connection being made

SCREENSHOTI have an excel sheet which is linked to a query in my Access database (both 2010 version). It works really well and I decided that I wanted to have the same excel sheet but to only contain data for an individual site.

So, I copied the query, renamed it and added the following criteria under the site field: [Forms]![BASIL-3 CRF Tracking]![Selectsite] ... the query works fine it only retus results from the site selected from a pull-down box on a form in the db.

However, when I go to excel, that new query isn't listed to connect to. If I delete the above expression in the query then it re-appears in the list. If I make the connection to the query then add the expression in and then refresh the connection I get an error (see attachment)- Help very much appreciated.

Recent Questions...