How to pass a variable to filter statement

[MilaK]

Hello,

I'm using the following loop to filter multiple subforms on a Main_form:

strform = "frm_subform"

For j = 0 To 2
        Debug.Print sample_array(j)
        y = j + 1
        c = CStr(y)
        Debug.Print c

        numbered_form = strform & c    'corresponds to the name of each subform that will contain a different number extension for each loop iteration
       
        Criteria = "[sample_name] = '" & sample_array(j) & "' AND [run_name] = '" & Run_Name & "'"
Debug.Print Criteria
       
        Forms!Main_form.[B]numbered_form[/B].Form.Filter = Criteria
        Forms!Main_form.[B]numbered_form[/B].Form.FilterOn = True
    Next j

I would like to pass a string variable that contains the name of the subform to the Criteria statement, since it will be different each loop iteration.

How do I incorporate string variable into Filter criteria statement? Thanks, Mila

 

[CJ_London]

you should find this link useful - how to reference any form from any other form

http://access.mvps.org/access/forms/frm0031.htm