Refilter Report On The Fly?

[DAmoss]

I have a popup form that lets me enter the Start & End dates which I then filter a report by. The popup stays open until I hit the close button.

Is there a way to refilter the open report if I enter new dates?

Do I need to close the the report and reopen it? If so, how do I check that the report is already open?

Cheers

 

[kjv1611]

If you use something like this:

Private Sub Test_Click()
    DoCmd.OpenReport "MyReport", acViewPreview
End Sub

It shouldn't matter whether it is open or not. Give it a try.