A form for 7 reports

  • Thread starter Thread starter Mavis
  • Start date Start date
M

Mavis

Hi All,

I have a switchboard with 7 reports and a form for user to select the
country. i will like to have something like for example, in the switchboard,
the user will select report 1, then the country form will prompt the user to
select the country. After select the country, the user will click the "OK"
button and the report will run as per the country is selected.
can anyone know advice how can i use a form with a OK button for all 7
reports?

Thanks!
 
I have a switchboard with 7 reports and a form for user to select the
country. i will like to have something like for example, in the switchboard,
the user will select report 1, then the country form will prompt the user to
select the country. After select the country, the user will click the "OK"
button and the report will run as per the country is selected.
can anyone know advice how can i use a form with a OK button for all 7
reports?
Click to expand...

Think about this in reverse. What if the 7 reports each called the
same form to prompt for your country before proceeding?

Have a report prompt the user for criteria before it runs by opening a
form from the report's Open event. Open the form in Dialog mode so
that the report waits for the form to be closed or hidden before it
proceeds. That way you can collect criteria from the user and build a
Where clause for the report. It also means that you can call the
report directly - you don't need to call it from a form. And the
selection form is reusable - it can be called from multiple reports if
they need the same criteria. So you can easily create more than just
the 7 reports you have now.

I've posted examples of this technique at
www.JStreetTech.com/downloads - see "Report Selection Techniques".

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Hi,

Thanks for your advice. I am very new to access and still not very sure what
to do. Can you advice in detail what is the steps i should do.

Thanks alot.
 
Thanks for your advice. I am very new to access and still not very sure what
to do. Can you advice in detail what is the steps i should do.
Click to expand...

Hi Mavis,

The technique I mentioned requires you to use some VBA programming. I
can't really lay out all the necessary steps for your specific
situation - you would need to adapt the example code I mentioned to
your own needs.

If that's more complex than you want to tackle right now, then you can
still use your form to run each report separately. On your form,
allow your user to select a Country. In the query of each report,
include a criteria of Forms!MyForm!MyCountryControl. Then you can
launch report 1 - 7 using buttons, and each one will run just for the
selected country.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top