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.
Code:Private Sub Bijschrift572_Click() DoCmd.OpenForm "FormMagazijn" With Forms(SubFormMagazijn) Me.Filter = "Magazijn_stelling = '61'" Me.FilterOn = True End With End Sub