How do I set a filter on my Switchboard that will filter all repor

[Rachael]

I am building a Switchboard that runs reports. Each report hits a query.
each query has one table in common. that table was created with a make table
query.

Question 1: How can I add a button in my switchboard main menu to auto run
that make table query. (or get it to run when the switchboard opens).

Question 2: How can I set a filter on the table so that all of the reports
the run from my switchboard show only the filtered data?

THANKS!

 

[Alam via AccessMonster.com]

I am building a Switchboard that runs reports. Each report hits a query.
each query has one table in common. that table was created with a make table
query.

Question 1: How can I add a button in my switchboard main menu to auto run
that make table query. (or get it to run when the switchboard opens).

Question 2: How can I set a filter on the table so that all of the reports
the run from my switchboard show only the filtered data?

THANKS!

Its just a suggestion

Make a unbound Form Which you can open from the Switchboard

Make several combo box. Record sources from your table/query

Use group option to select the report by hide and visible according your
selection
Using if and else to show each combo Box

In you report query under criteria write forms![Your report Swithboard Name]!
[YourComboBox Name]

Put Command button on Switchboard
Call each report with group option selection

Good luck