Runing a report from combobox

[frksdf]

Hi All;
My question is really simple for the experted user rahter than dummies like me.
I have three reports

• REPORT1
• REPORT2
• REPORT3

And i create a form with a combobox. You can see the list of the reports in the combobox's drop-down list. Also this form has a button.
I want to select a report name from combobox and click the button to run the report.
I couldn't find a suitable code. Could you please show me a code and which module type i will insert in, class or standart module?

Thank you very much.

[June7]

Code goes in the Click event of button or eliminate the button and use AfterUpdate event of the combobox.

DoCmd.OpenReport "[" & comboboxname & "]"

This will send report straight to printer (the default action). Check out the other arguments of the OpenReport method in VBA Help.

[TinaCa]

You may need to delete any code the combo box created. sometimes when you create the combo box will create a macro, so check the properties under the Event tab and delete the macro from the- probably- on change, or on click event. Then put the code above - in the afterupdate event.