Combo Box with Macro Question

[Guest]

I have a combo box that points to a list of available reports, the issue that
I am having is this,
On the event "click" I run a macro that runs the selected report, the
problem is that the macro does not understand which report I selected from
the combo box.
What am I doing wrong?

Thanks,

 

[Duane Hookom]

Assuming your combo box is bound to a list of reports, leave macros to
others and use code. I would not tie the opening of the report to an event
of the combo box.

Add a command button to your form and use the command button wizard to open
any one of the reports. Then modify the code to replace the report name with
something like:

DoCmd.OpenReport Me.cboReport, acPreview