unloading Active reports

[newbie2]

Hello
I'm having big trouble to unload my active report from another form.

Unload Activereport1
Set ActiveReport1 = nothing

these codes are not unloading the Activereport.
Any suggestion?
thanks

[DataMiser]

If you make a reference to a control after you unload it then you are effectively reloading that control.

Get rid of the second line.

[LeoFar]

If you make a reference to a control after you unload it then you are effectively reloading that control.

Get rid of the second line.

I Agree 100%

[newbie2]

I'm so sorry
I was just mistaken
The codes are:

Unload Activereport1
Set ActiveReport1 = nothing

these codes are not unloading the Activereport

[LeoFar]

ActiveReport1 is not an 'object variable', but it is a real object and cannot be set to Nothing, that statement is useless and must be removed because you cannot 'download' the report!


It would be like if you wanted to download a TextBox using Set TextBox = Nothing, it doesn't make sense.



In my projects I only ever use Unload.

It would be like if you wanted to download a TextBox using Set TextBox = Nothing, it doesn't make sense.


In my projects I only ever use Unload.

[DataMiser]

An Unload should be all that is needed. If that doesn't work then there is something else going on and would need more info as to how the report is loaded and where that unload statement is located.

For example

ActiveReport1.Show 1
Unload ActiveReport1

Will not work because the unload code will nto run until the report is hidden or closed.