Closing and opening report when selecting different values from a combo box

[Varda]

Using Access 2010


I have a form with a combo box, and two command buttons.



When the user selects a record in the combo box, the command button pressed opens a report filtered by the criteria selected in the combo box.

I'm trying to allow the user to select a different value in the combo box, and close the report that is already open, so the report can open again for the new criteria selected in the combo box.

I'm assuming I would place the code in the On Change of the combo box. What is the code I need to place?


Or what keywords should I search on YouTube?

Varda

[June7]

I would use combobox AfterUpdate event.

You want to check if the report is already open then close it if it is.

If CurrentProject.AllReports("reportname").IsLoaded Then

However, if the report is open in Print Preview and is on top of the form, won't they have to close the report with X close button to get back to the form?

[Varda]

Yes, the report is open in Print Preview and is "on top" of the form. The form actually stays open, and I can select a new name and run the report again - which is why I'm asking about a way to close the current report, so I can select a new name to filter the report by.

I tried your code above, and it doesn't close the report, it just opens another tab with the new report (I have two command buttons opening a different report each).

I'm trying to skip the step of having the user close the report on the x close button, so they can easily select a new name, and print the new report.


Varda

[June7]

Post your code for analysis.

Oh wait, your db is set for Tabbed Documents - I always use Overlapping Windows.

[Micron]

What's the code you tried? I don't see why
If CurrentProject.AllReports("reportname").IsLoaded Then
docmd.close "reportname"
docmd.open"reportname",etc.
end if
would not work, even for preview, even in tabbed documents. I'm sure I've done this many times. You change the combo box value, then click to re-open the report with new data.