Combo Box

[jereece]

I have a database with reports. I want to create a form with a combo box which contains a list of the 6 reports so that the one selected will launch. How can this be done?

Thanks,
Jim

 

[Pat Hartman]

The following query can be used as the recordsource for your combobox.

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type = -32764;

In the double click event of the combobox, use the OpenReport method to open the selected report.