Report based on selected pop up option selected

[NEEDHELP123]

I want to create a report based on business unit information. I have a switchboard that links to the report. When the user double click to see the report I want a pop up message asking them what division he/she wants to view. Based on the division selected the report will show only those business units the rolls up to that particular division.

How should I proceed????

 

[Smart]

Create a query that selects all the information needed for the report
In the division column of the query in the criteria section type
[Please Enter Your Division]

now change the reports data source to be the query that you just created

Now when you run the report it will prompt you for the division

me personaly I would have a form with a combo box that shows all the divisions.the query would have in the division column in the criteria section
forms![Myform]![mycomboboxname]

click a button and the report runs taking the division parameter from the combo box

 

[NEEDHELP123]

Thank you for helping with this issue. I can't believe it was so easy.

Do you know how to write a if...then statement in combo box (forms). ie. if division 1 is sellected, give me all business units related to division 1 only.