Report is unable to open in Design view

[fluffyvampirekitten]

I wanna edit the report but I'm unable to open it in a design view .
The error that i see is:



Run-time error '2186'
This property isn's available in Design view.

Private Sub Data_Retrived()
Dim DB As String
Dim DataSource1, DataSource2 As String
Dim C_SOURCE, c_Category, C_QUERYTYPE, c_FieldMatched As String
    DB = "CrossSystemData"
    
    c_Category = "='" & Forms!Frm_Verification.cbo_category & "'"
    
    
    If Forms!Frm_Verification.cbo_Type = "ALL" Then
        C_QUERYTYPE = "Is Not Null"
    Else
        C_QUERYTYPE = "='" & Forms!Frm_Verification.cbo_Type & "'"
    End If
    
    If Forms!Frm_Verification.cbo_FieldMatched = "ALL" Then
        c_FieldMatched = "Is Not Null"
    Else
        c_FieldMatched = "='" & Forms!Frm_Verification.cbo_FieldMatched & "'"
    End If
        
    If Forms!Frm_Verification.cbo_institution = "ALL" Then
        c_institution = "Is Not Null"
    Else
        c_institution = "like '" & Forms!Frm_Verification.cbo_institution & "*'"
    End If
      
    DataSource1 = "SELECT * FROM " & DB & " WHERE C_TYPE = 'CROSS' AND " & _
                 " Category " & c_Category & " and Query_Type " & C_QUERYTYPE & _
                 " and FieldMatched " & c_FieldMatched & " and Institution " & c_institution & _
                 " ORDER BY FieldMatched, Group_No, Query_Type"
                 
    RecordSource = DataSource1
End Sub

This is highlighted when i clicked on "Debug" button. I can't figure out what's wrong with this line
Could anyone help me ?
Thanks in advance!

c_Category = "='" & Forms!Frm_Verification.cbo_category & "'"

[pbaldy]

It's a shot in the dark, but the variable isn't declared as a string. Try

Dim C_SOURCE As String, c_Category As String, C_QUERYTYPE As String, c_FieldMatched As String

[fluffyvampirekitten]

It's a shot in the dark, but the variable isn't declared as a string. Try

Dim C_SOURCE As String, c_Category As String, C_QUERYTYPE As String, c_FieldMatched As String

Now there's a different error

Run-time error '2450'

Patient Unit cannot find the referenced form 'Frm_Verification'

[pbaldy]

I suppose that's progress. Is that form open? Spelled correctly?

[fluffyvampirekitten]

I suppose that's progress. Is that form open? Spelled correctly?

Yep, its open. Because i placed the button there (Export to excel) and yes, its spelled correctly .

[pbaldy]

You can try this to make sure the SQL is right:

http://www.baldyweb.com/ImmediateWindow.htm

can you post the db here?

[fluffyvampirekitten]

You can try this to make sure the SQL is right:

http://www.baldyweb.com/ImmediateWindow.htm

can you post the db here?

I can't post the db cos of the sensitive data

[pbaldy]

Did th link help then?