Error2467 The Expression You Entered Refers to an object that is closed or Doesn't

[bconner]

All,
I have an Access 2003 Data Project with SQL Server 2008 Back End. When the user selects a drop down list I am trying to assign the recordsource of a subform and I keep getting the following error:
Error 2467 "The Expression You Entered Refers to an object that is closed or Doesn't Exist"

Here is the Code I am using:

Select Case cmb_WorkList_Area
 
          Case "$250.01 TO $999.99"
            Me![Frm_All_Demographics].Form.RecordSource = "SELECT [MEDICAL RECORD], SUM([Current Inv Balance]) AS [Current Inv Balance]" & _
                                                          " FROM [Tbl_AP]" & _
                                                          " WHERE [Work Area] = '$250.01 TO $999.99' AND [Action Taken] IS NULL AND [GROUP] = " & [Forms]![Frm_Main]![cmb_Group] & " " & _
                                                          "GROUP BY [MEDICAL RECORD]"

 

[Beetle]

Assuming that the main form/sub form in question is actually open, have you verified that the Subform Control (the "window" that holds the subform) is actually named Frm_All_Demographics? The Subform Control may or may not have the same name as the subform itself.