I have a database (for engineering drawings) that uses 7 different filters on a continuous form by building an SQL statement.

I would like to generate a report using the same filters.
I have tried Me.Filter = Forms!DwgSearchF.Filter, but that does not use the SQL filters.
I have tried DoCmd.OpenReport, but I am not sure if it is possible to pass the SQL Where statement or how.
The filters are:
Private Sub AreasFilter_AfterUpdate()
    RequeryForm
End Sub

Private Sub ClassFilter_AfterUpdate()
    RequeryForm
End Sub

Private Sub RemarkFilter_AfterUpdate()
    RequeryForm
End Sub

Private Sub SubjectsFilter_AfterUpdate()
    RequeryForm
End Sub

Private Sub EquipFilter_AfterUpdate()
    RequeryForm
End Sub

Private Sub KeywordFilter_AfterUpdate()
    RequeryForm
End Sub

Private Sub ByFilter_AfterUpdate()
    RequeryForm
End Sub

The sub to build the SQL statement ends like this:
...
If RemarkFilter <> "" Then
        If WhereStr <> "" Then WhereStr = WhereStr & " AND "
        WhereStr = WhereStr & "REMARK Like ""*" & RemarkFilter & "*"""
    End If
    
    SQL = "SELECT * FROM DrawingT"
    SQL2 = SQL

    If WhereStr <> "" Then      'If a WHERE string exists, add it to the SQL statement
        SQL = SQL & " WHERE " & WhereStr
    End If
    Me.RecordSource = SQL
    SQL2 = SQL
End Sub

Thanks for your help.