Creating a list box

[Jasper Recto]

I want to create a list box that runs different applications depending on
which item is choosen.

How could I go about associated each item on a list to run a specific
application like word or excel:

Thanks,
Jasper

 

[Guest]

You have a few choices. The most robust way is to include all relevant data
in a table the layout might look something like this:

id (autonumber key)
option description
Program to run
Arguement

It then becomes a matter of determining what needs to be done when the
option is selected. If you pull all the data into the combo but don't show
it you can reference it within the combo box row. Otherwise you can grab the
table's recordset and go from there.

You can also simply embed your data in the combo box, but that isn't
recommended.

If you need to know how to actually open Word, Excel, etc. that's a
different question, there are lots of examples of that floating around.

 

[Jasper Recto]

In your example of putting all relavant data in a table, where would I put
the command to execute the application?

Thanks,
Jasper