Thread: How can i Select a Report From Dropdown

Hi everyone,

I have inherited a database that has a list of reports in a drop down. Whenever I select a report, the preview window will open but it will automatically default to the first report on the drop down list (even if I selected the 5th). How can I open ONLY the one selected from the drop down, rather than all of them each time (regardless of which I chose)?

The query behind the drop down is:

Code:

SELECT [Overall Rankings].[Site ID], [Overall Rankings].[Site Name], [Overall Rankings].Address, [Overall Rankings].City
FROM [Overall Rankings]
ORDER BY [Overall Rankings].[Site ID];

The code behind the button opening the report is:

Code:

Private Sub btn_ViewSiteSummary_Click()
On Error GoTo Err_btn_ViewSiteSummary_Click

Dim stDocName As String

stDocName = "Site File Review Summary Report"
DoCmd.OpenReport stDocName, acPreview