In my question there are 3 objects to be considered.
1. "FormA" which contains combo boxes in which the user makes selections in order to filter data in "SubformA"
2. "SubformA" which appears on the bottom of "FormA" in a datasheet view.
3. "QueryA" which provides the data for "SubformA" using the criteria provided in "FormA"

My problem is applying the filter. I have been toying with ReQuery and refresh commands and cannot get this form to work properly. Essentially "AfterUpdate" of each combo box, I want the query that powers the subform to rerun as well as the subform to refresh. Can anyone help me? I appreciate any help!
Thanks,
Justin

Hi Justin,

You should be able to simply set the subform's record source property in code based on combo box criteria, like:

On Error GoTo cboSelect_AfterUpdate_ERR

    Dim strSQL As String
    Dim strCriteria As String

    strCriteria = "FieldID = '" & cboSelect & "'"

    strSQL = "SELECT * " & _
                "FROM qSel_Data " & _
                "WHERE " & strCriteria

    ' Set sub form's recordsource and requery
    fsubSubForm.Form.RecordSource = strSQL
    fsubSubForm.Requery

End Sub

HTH,

Bob

Bob,

Thanks again for all your help. You have really helped me finish this project. I can't thank you enough.

-Justin

My pleasure Justin. Glad its working for you :).

Bob