change reports record source

I have a report and I want to change the recordsource from qryWPPI_Funding to qryWPPI_Funding_Null.
I can't seem to do it.  

Can I only do it in design mode?  If so, could I open the report in design modem change the record source and then change the view to preview?

Thanks, JOe K,Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

Private Sub Report_Open(Cancel As Integer)
    Dim sSql As String
    
    If IsNull([Forms]![jobsstatsinfoform]![MonthIndicator]) Then
        Me.RecordSource = "qryWPPI_Funding_Null"
    Else
        Me.RecordSource = "qryWPPI_Funding"
    End If
    
End Sub