Good Morning! I spent the better part of the day trying to figure this out using Google, but nothing has yielded proper results.

Background:

1. I am cataloging Journalists, Articles they write, etc.
2. I store all my journalist information in one table, all the news article data in another. There is a one to many relationship between journalists and news articles by joining on idJournalist; this is the PK in the journalist table and a column in the article table.
3. News articles have additional tagging, so let's call that additional tag "focus"
4. I have a main report that pulls from the Journalist Table. I have a couple sub reports, linked via the idJournalist fields.

Running this report gives me everything it works great. All the journalist information at the top, then the subreports have all the articles they ever wrote and I have cataloged, their social media information (stored in another table to simiplify and maximize growth potential), and another sub report that has some of my thoughts about the article.

What I need to do is customize the report and tailor each of these sections. Examples:

1. I want all the articles related this focus area
2. Limit to this date range.
2. I want this specific journalist.
3. A combination of the above.

I created a form to capture my refining options, the journalist selection is passed as as a WHERE condition in the DoCmd.OpenReport line in my form and in the OnOpen event for the article sub report I used:

[code]
Private Sub Report_Open(Cancel As Integer)
    
    Dim SQL
    SQL = Forms!ReportGenerator_F!SQL4

    If Not IsNull(SQL) Then
        Me.RecordSource = "SELECT * FROM MediaArticleList_ForReports WHERE " & SQL
    End If
End Sub
[/code]

I build the WHERE statement in the form and pass it along to the subreport. But I am getting the Runtime error 2191: You cant sent the record source property in print preview or after printing has started.