Using a drop down combo box on a form to update a report

[Andy959]

I have a navigation form that uses a drop down menu to select data for a query. You can then click on different tabs to view different reports based off the drop down menu.

Currently you have to select the item in the drop down menu, then click the tab for the report. If you want to change the item in the drop down menu you have to re-click the same report to update. Is there a way to make the report update every time something is selected from the drop down menu?

Thanks!