Filtering a query based subform using unbound form

U

Underpaidadmin

I have a form called [sbfBrowse] that uses a query to get data from several
tables. Most of the tables are linked by a text field called [CaseNum]. I
have an unbound form called [frmSearchIt] with 6 unbound text box controls, 4
unbound date controls, and [sbfBrowse] at its Form Footer. What I want is
the user to enter values into [frmSearchIt]'s controls, hit a button which
filters [sbfBrowse] based on all the values entered in [frmSearchIt]. I have
made If statements to get those values but I don't know if I should be
storing those to a WHERE/SQL/or some other string or value. My current code
for opening [sbfBrowse] is :

If Not Me.FormFooter.Visible Then
Me.FormFooter.Visible = True
DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
End If
With Me.sbfBrowse.Form
.Filter = Mid(strWhere, 7)
.FilterOn = True
End With

I keep getting an error I can't assign a value to this object. For the line
".Filter= Mid(strWhere, 7)"

I have reached a point that I don't know what else to do, so I would greatly
appreciate help.
 
Top