view and print reports from form

[jlnewbie]

I want a form to view all reports, select one and print the one selected. Just point me in the right direction, I take from there. I originally thought that a combobox orlist box would show me these reports but is only allows for queries or table. I don't know where to start. A somewhat newbie, thanks in adavance



JLopez
Lopez31@ATC-Enviro.com
Environmental Services @ Your Service

 

[HitechUser]

Jlopez,

Try this....

SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND (MSysObjects.Type)=5 ORDER BY MSysObjects.Name;

I hope this helps...

 

[HitechUser]

Ohh.... then just do a DoCmd.RunQuery (see help text) from your list ....

 

[PHV]

You may also take a look at the CurrentProject.AllReports collection.

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