View Full Version : Combo Box


jereece
12-11-2001, 03:02 PM
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
12-11-2001, 06:46 PM
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.