Too many Buttons

[mdg]

I have several forms that are used to input data and run reports. Some of my forms have numerous buttons that each run a single report of one kind or another or open other forms. I would like to change all the buttons to a couple of drop down list so that I can select which report or form I want to run and remove all the buttons. This would clean up my form too. I tried several methods but none seem to work right. Thanks for any suggestions anyone may have.

 

[pbaldy]

Presuming the combo's bound column is actual report names:

DoCmd.OpenReport Me.ComboName

with the appropriate arguments.

 

[mdg]

Presuming the combo's bound column is actual report names:

DoCmd.OpenReport Me.ComboName

with the appropriate arguments.

Thanks for your kind reply. I was trying to do that using an event procedure and combo box like above but was having trouble here. I will keep working at it.

 

[pbaldy]

No problem. Post your actual code and what the problem is if you get stuck.

 

[Alansidman]

Look at the example in the next to last item and the one above it in this link

http://www.btabdevelopment.com/ts/samples