Using a combo box to open up files

[Freida]

I have several crystal reports that I want to add to a form. Originally I
had several command buttons, but it made the form look cluttered. I want to
create a drop down box that has a list of all the crystal reports. The
trouble that I am having is I don't know how to associate the macro with the
selection rather than the actual box.

Here is an example:

Report A H:\reports\reporta.rpt
Report B H:\reports\reprotb.rpt

How do I associate the selection with the path?

 

[Stockwell43]

Hi Freida,

If all you are trying to accomplish is to link the drop down box to the
report location, you can create a table theat feeds the drop down box and
have the field type in the table set to hyperlink.