DropDown List for Reports

[Jass7869]

Hello,

I have a dropdown list of reports that is supplied by table. I also have listbox that are populate by another table. I want to be able to run the reports from the dropdown and from the listbox ....whatever the selection is to pull that info from the report and display. I know Access but definitely not an expert.

Can anyone help?

 

[pbaldy]

DoCmd.OpenReport Me.DropDownName ...

 

[Jass7869]

Hello,

I have a few reports will it open all of them as they are clicked on. Also I want to open in "View" for some resaons it wanted to print

 

[pbaldy]

That would open whatever report was selected in the drop down. To preview, add the appropriate argument. Check in help for the argument and its position.