Filters by Subquery are not working

[eksortso]

I had an application, an MDB with all tables linked to SQL Server, where I would call DoCmd.ApplyFilter on an Order form and use a WhereCondition like the following:

EXISTS (SELECT 1 FROM OrderDetails AS x WHERE Orders.OrderID = x.OrderID AND x.Received = 1))

Now I am try to develop an ADP, but this same sort of filter fails! I get this error message: "Cannot apply Filter on one or more fields specified in the Filter property."

What am I doing wrong? Why won't this filter work?

 

[eksortso]

Never mind. I've since discovered that I can apply this query as a Server Filter without any problems.