VB Data Report Open

[rasty1611]

Hi,

I have a DataEnvironment and a DataReport in my Visual Basic project, in which I am using Access database. When I produce the report, during run-time, and when I close the report, and try to execute another SQL query to produce a second report I get an error, that the object (my DataReport) cannot stay open...

Can anyone pls help?

[d3gerald]

i dont know if this is right or if it can help but just try this.

on the terminate event of your query, set the datareport recordsource = nothing

[rasty1611]

the run-time error that appears is :

"Run-time error 3705: Operation is not allowed when the object is open"

And when I press "Debug" the error is located in line:
DataEnvironement1.Command1 mystr1
at the object DataEnvironment

[rasty1611]

I have the following code:

DataEnvironment1.Command1_Grouping mystr1
DataReport1.Show

and when this is executed for the first time I get the report and everything is ok.
when I close the report and try to show another report (with a different mystr1) I get the error:
"Run-time error 3705: Operation is not allowed when the object is open"

How can I close the object: ataEnvironment1.Command1_Grouping???

[rasty1611]

I meant the object:
DataEnvironment1.Command1_Grouping???

sorry