Unanswered: Run Access report from ListBox selection.
Hi there, I have a listbox with the names of reports that someone can run just by selecting on or two of the report names that appears within the list that comes from TABLE_REPORT_NAMES. With the following code, I am able to run this code and populate a secondary table (TEMP_TABLE_REPORTS ) with the selections that have been made. Now I need to be able to run the report that has been selected and am totally lost. Hopefully someone can help me with this.
Private Sub BTN_RUN_REPORTS_Click()
Dim rs As New ADODB.Recordset
Dim cnn As New ADODB.Connection
Dim strSQL As String
DoCmd****nSQL "DELETE TEMP_TABLE_REPORTS.* FROM TEMP_TABLE_REPORTS;"
Set cnn = CurrentProject.Connection
strSQL = "SELECT * From TEMP_TABLE_REPORTS"