Open formB and filter the suform on formB with formA

[Carloj]

I want to open a form with a filtered subform.

The main form is called: FormMagazijnMenu
The form with subform is called: FormMagazijn


And the subform is called: SubFormMagazijn

It needs to filter field "Magazijn_Stelling" in the subform to the value "61"

I got this code so far but it's not working or giving any error.

Private Sub Bijschrift572_Click()

    DoCmd.OpenForm "FormMagazijn"
    
    With Forms(SubFormMagazijn)
    Me.Filter = "Magazijn_stelling = '61'"
      Me.FilterOn = True
    End With
End Sub

[pbaldy]

"Me" always refers to the object containing the code, in this case presumably FormMagazijnMenu. Use the full reference to the subform:

Forms Refer to Form and Subform properties and controls

[Carloj]

Im sorry, but im not understanding those i always get the error it can't find the field.

Private Sub Bijschrift572_Click()

    DoCmd.OpenForm "FormMagazijn"
    
    With Forms(SubFormMagazijn)
    Me.FormMagazijn!SubFormMagazijn.Filter = "Magazijn_stelling = '61'"
      Me.FormMagazijn!SubFormMagazijn.FilterOn = True
    End With
End Sub

[pbaldy]

You're still using Me. More like:

Forms!FormMagazijn!SubFormMagazijn.Form.Filter = "Magazijn_stelling = '61'"

[Carloj]

Ahh now i get it. Thanks alot!
This code works for me:

    DoCmd.OpenForm "FormMagazijn"    
    With Forms(SubFormMagazijn)
        Forms!FormMagazijn!Sub848.Form.Filter = "Magazijn_stelling = '1'"
        Forms!FormMagazijn!Sub848.Form.FilterOn = True
    End With

[pbaldy]

Happy to help!