Hello VB amigos, I have seen the answer to this problem on these boards before and now that I actually need to refer to it, of course I can't find it.

I'm using the Data Environment and Data Reports to create reports. In my program the user can run one query effectively but then every following query shows the same info as generated by the first. I have in the Data report Terminate event

Set MyDataEnvironment = Nothing

which sometimes works and sometimes doesn't.

Help, please?

Thanks in advance

Andrew