form chooses report from multiple reports

[Jecker]

I would like to request some assistance please. I have created a form to run
reports for me. The obstacle I've come upon is I have 12 reports and I need
this form to know which report to run based on the 'plan' that is chosen.
i.e. if I chose 'PER' on the form I want it to run the 'PER' report, if I
choose 'FSR' on the form, then I want it to run the 'FSR' report. I also
need these reports to be separated by office when they are ran. So I need a
PER report for State Street, and a PER report for Berkley Street, etc
Any assistance would be helpful

 

[Tom van Stiphout]

On Fri, 4 Sep 2009 06:43:17 -0700, Jecker

You could add a ReportName column to the Plan table. That way you will
know what report to run for each plan. Consider making this a required
field.

As far as the Office is concerned: you either ask the user to select
it from a dropdown, or perhaps the value is already known some other
way - I don't know your application.

-Tom.
Microsoft Access MVP

 

[Jecker]

Thanks Tom, I'll try that and let you know..