Multiple filters on a subform
<p>Trying to apply 2 filters at the same time to a subform.</p>

<p>Want to see records between DATES X and Y, and from BRANCH Z only.</p>

<p>Working fine alone, but can't use both at the same time. I know it's something </p>

<p>Current code:</p>

<pre><code>Private Sub Command39_Click()
If IsNull(Me.txtFrom) Or IsNull(Me.txtTo) Then
    MsgBox "Insert date!"
Else
    With Me.frmDailyRevenue.Form
        .Filter = "[DateDbl] BETWEEN " &amp; Me.txtFromDbl &amp; " AND " &amp; Me.txtToDbl &amp; "" And [F5] = " &amp; Me.cboBranch &amp; """
        .FilterOn = True
    End With
  End If 
End Sub
</code></pre>

<p>This is basically bits of code I got from the web as I'm really new to this.</p>

<p>So, all advice is welcome.</p>