Advice on DataEnvironment and DataReport

[alexisa]

I have a DE and a DataReport properly attached to a database and the report I designed is properly displayed. However after I close the report screen and return to where the report was called from and want to execute it again or execute a different report I get the error "cannot process this report while the object is open". I take it that this means the DE needs to be closed or refreshed somehow.I have tried different things with no luck.<br>
Any ideas??<br>
Any help will be more than appreciated.<br>
Thanks<br>
Alexis

 

[Misled]

The open object is a recordset. Examine the state property of the recordet before executing it. If it is open then close it and rerun report.

 

[FailSafe]

Try this:<br>
If RS.State = adStateClosed then<br>
RS.Open<br>
End If