I have a report with a recordsource = select * from table1 where x = 200. This runs fine locally. When I run it through citrix, an activex control on the screen gets corrupted. If I remove the where clause it runs fine under citrix. Tech support for the active control has been no help. They say they gave up their citrix license because their control works fine with it.

I've tried using an ADO recordset (recordset.souce) but I get the same results.

I'm now trying to take that query and put it in a temporary table in the database and then connect the recordsource to that temporary table. I know this is very clunky but I really don't have a choice. I can't have a where clause if I want this activex control to work.

I'm so new to Access and ADO that I can't figure out how to do it. Can someone help me out?