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 - 24 Apr 2008 15:30 GMT
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

Signature
Dave Hargis, Microsoft Access MVP
> I have a button to preview a report using my controls as parameter.
>
[quoted text clipped - 5 lines]
>
> Your information is great appreciated,