Drop Down Report List

[denileigh]

Is there anyway to have a list of reports in a drop down format?

I have a screen with about 14 buttons on it and it would look so much nicer if I could figure out how to do that.

Thanks for any help.

 

[WayneRyan]

denileigh,

ComboBox RowSource:

Select Name
From   MSysObjects
Where  Type = -32764

Then on the button to run a report:

DoCmd.OpenReport Me.YourCombo

Wayne