Running a report by selecting different criteria from a form 1

[akash2010]

Hello,

I am VERY very new to MS Access and here is my question -

I created a form, which has various drop down menus and I want the users to select different criteria and run a report. So it's basically like:

If Combo15 = "North America"
Then Runreport = "North America Sales"
Else
If Combo15 = "South America" and so on...

Any help would be very very appreciated and thank you for your patience.

-A

 

[MajP]

Look at the
Docmd.openreport

http://www.blueclaw-db.com/docmd_openreport.htm

Also if your region is a field then it is possible to just build one report and filter the report when it opens to the selected region.