I saw something like this a few month ago while browsing for some code.
It was something like
Report record source is a saved query names "qryReport1"
you have the combo box (I'll call it "cboTableSelect")
button click to open report then
sSQL = "Select Field1, Vield2, Field3 FROM " & Me.cboTableSelect
"qryReport1" SQL is modified by saving the sSQL variable to "qryReport1" query def
Report is opened. (sorting and grouping is done in report). Filtering can be done using the docmd.OpenReport WHERE option
Found something... something like this
Code:
Option Compare Database
Option Explicit
Public Sub btnReport_Click()
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim sSQL As String
Set db = CurrentDb()
Set qdf = db.QueryDefs("qryReport1")
sSQL = "Select Field1, Vield2, Field3 FROM " & Me.cboTableSelect
qdf.SQL = sSQL
DoCmd.OpenReport "Report1", acViewPreview, , "Field3 = 'ABC'" 'WHERE filter Field3 = 'ABC'
Set qdf = Nothing
Set db = Nothing
End Sub
Warning: untested code!!