Access 2003 - Combo box with list of reports

[kjmast]

Hi all

I have created a combo box that lists the reports available in my database by querying the 'MSysObjects' table. My problem is this...how do I then actually preview or print the report after it is selected in the combo box? The following link helped me with some of this; however, not being a programmer, I think I lack the capability to go the extra mile to print the report. Thanks for your help....

http://www.tek-tips.com/viewthread.cfm?qid=1046082

 

[PHV]

What is your actual code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kjmast]

I apologize...I should have said I didn't use the code. I basically attached the qry to the properties of the combo box under Row Source Type (Table/Query) and Row Source (QryListofReports).

 

[PHV]

Have a look at the DoCmd.OpenReport method and perhaps at the Column property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886