report with combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to dispaly my reports listing (10-20 reports) through a combobox to
run it. How can I do that.

Please help
 
Create a form with the combobox loaded with the reports listing. In design
view click on menu VIEW - Properties. In the After Update property call a
marco.

Create a macro and put OpenReport as action. Put your reports as arguments.
Click on menu VIEW - Conditions.

Use the following as the condition --
[Forms]![YourForm]![YourComboBox] = "Text name in the combobox"
Substitute your form name and combobox label. Type in the name of indicated
in the combobox listing.

Save.

When you select a report in the combobox the report will run.
 
Pushpendra,

To get the names of your reports listed in a combobox, you will need one
of these 2 approaches...
- make a table with a single text field where you enter the names of
your reports, and then use this table as the Row Source of the combobox
- set the Row Source Type property of the combobox to Value List, and
then in the Row Source property type in the names of the reports,
separated by ;s

You can then put a macro on the After Update event of the combobox, or
on the CLick event of a Command Button on your form. The macro will be
like this...
Action: OpenReport
Report Name: =[NameOfYourCombobox]
 
Back
Top