You can do whatever you want. Usually you're more limited by your imagination then what you could code up to do (or at least APPEAR to do with some trickery).

You will need to put the filter on the actual subform. Depending on your comfortability, VBA may be easier to accomplish it. You'd just need to call to the subform and apply a filter
Value From a Form

My Form is Budget.
My Subform is TransactionSubform.
One of the combo box filters is AccountFilter.
The filed in the subform is Account.

I think it's this part of the Event from this video that needs to be updated, but not sure how to do it so that it will select the field in the subform.

Can someone help?



Private Sub AddToFilter(FilterComboName As String)

    If IsNull(Me(FilterComboName)) Then Exit Sub
    If TempVars("Filter") <> "" Then TempVars("Filter") = TempVars("Filter") & " " & AndOrCombo & " "
    TempVars("Filter") = TempVars("Filter") & _
        Left(FilterComboName, Len(FilterComboName) - 6) & "=""" & Me(FilterComboName) & """"

End Sub

I did have it filtered by the Query, but wanted to do it this way so that I don't have to update the query every time I add a new search field since this way will include it automatically.

Where is tempvars coming in? I don't recall seeing that in the video.

You should be able to do from the main form
Forms!FormName!SubFormName.Form.Filter = "State=""" & StateFilter & """"
Forms!FormName!SubFormName.Form.FilterOn = True

Or from inside the subform just
Me.Filter = "State=""" & StateFilter & """"
Me.FilterOn = True

Search Form 2.0 This video might help you setup the Search/Filter code better.

It is in the video and used so that the field doesn't have to be specified each time. I'll see if I can get your suggestion to work. Thanks Adam.