Subform filter

[teel73]

I'm trying to open a form and filter the subform called "frmUpdate_sub". The main form is called "frmUpdate_main". I have a button on another form and the code behind it is:

Dim frm As Form
Dim frm2 As Form
Set frm = Form_frmUpdate_sub
DoCmd.OpenForm "frmUpdate_Main"
DoEvents

frm.Filter = "[Issue_Tracking_Status] = 'submitted'"
frm.FilterOn = True

The above code opens the form but it doesn't filter the subform.

 

[pbaldy]

The reference to the subform would have to include the main form:

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