The record source does not exist

[Guest]

I have the following code that I am running from a form which has opened a
report:
Public Sub btnSearch_Click()
Dim SQL As String
SQL = "SELECT Citation," _
& "CaseName," _
& "[Parties-Appellant]from tblPatentCaseInformation " _
& "WHERE ((([Parties-Appellant])='test'))" _
& "GROUP BY CaseName"

DoCmd.Echo False
DoCmd.OpenReport "CaseInformation", acViewDesign
Reports("CaseInformation").RecordSource = SQL
DoCmd.Close , , acSaveYes
DoCmd.OpenReport "CaseInformation", acViewPreview
DoCmd.Echo True

What can I do? The table exists, the fields exist. I can't find anything
in this database that relates to this issue. Please, can you help me????

 

[Guest]

Could somebody out there give me a hand? I would so appreciate it