requry SQL Reports

[ZanM]

OK... I have 2 reports in my database application on to generate infomation to be printed about the Customers with srvices that need to be preformed this month. The second is a custom input report that generates the same informatio only letting the user do so 3 or 4 months in advance. The problem I'm having is that once a report is generated if the user where to try and generate another report they would see the same information as was displayed in the first report they generate. I have a statement in the DataReport_Activate event

DataEnviroment.rsReport.requary

in one report it works fine does the job perfect but in the second(custom report) the statement cause an error

This operation can not be preformed while the object is cloased.


Is there some way I can load the report object or open it and then requary it before I show it?

I've tried a simple load report then the requary
doesn't work

Thankx

[ZanM]

also about every 3 or 4 times I run this thing vb crashes like I was subclassing. anybody got a clue why?