reopen report

[Souris]

I have a button to preview a report using my controls as parameter.

It seems the report does not close and re open when I change the parameters
from my controls and click the button to run the report again.

Is it true that I need check the report opening or not, if it does then I
need close the report and reopne it from my button click event?


Your information is great appreciated,

 

[Klatuu]

You do need to close it. You can test to see if it is open and if so close
it like this:

If CurrentProject.AllReports("ReportName").IsLoaded Then
Docmd.Close acReport, "ReportName", acSaveNo
End If