Help with Command Button

[Beefboy]

Here is what I am trying to do. I have about 30 reports in a list box. I want to be able to select a report and push a command button so it runs the report I have just selected.

Couple of Details/Questions
I typed all the report names into a list box
Should I use a combo box?
Should I type these report names into a table then link it to a combo or list box?

Any help is appreciated..

 

[mikec]

The list box or combo box is primarily one of cosmetics. What ever looks better to you and fits into the form. I've always beem partial to the neatness of Combo boxes.

As far as using a table, that would depend on how dynamic or static your report list is, and if you want other users to be able to edit the list. If the list doesn't change much, then you could type the names as part of the properties. If the list changes, or you want others to have access, a table would be a better way to go.

 

[ElsVanMiert]

I feel that it is a lot of work to write (and to MAINTAIN!) a hand-written list of 30 reports.
I would simply use the in-built system tables to read the names of the tables and display them in a
1.) listbox if there is enough space
2.) a combobox otherwise.