Filter

G

gr

Hello I have the following code on the OnOpen event of a
subreport

Dim strSQL As String
If Me.Parent.Name = "rptSuitcaseStatus" Then
Me.RecordSource = "qryAllOnMaintenance"
strSQL = "SuitcaseID = " & [Forms]!
[frmSelectSuitcase].[Form]![cboSuitcase]
Me.Filter = strSQL
Me.FilterOn = True
End If

And i get the following error message:
Error 2101: "The setting you entered isn't valid for this
property"

And Me.Filter = strSQL is highlighted..

any ideas?
 
Top