use subform filter and orderby parameters for a query

Question

I need to create a query to return the same records shown in a subform inside a opened form. So I have based the query on the same recordsource of the subform; then, i have set the query filter and orderby properties with [forms]![myformname]![subformcontrolname].[form].[filter] and [forms]![myformname]![subformcontrolname].[form].[orderby]. However, the query always returns all the records in recordsource as if filter and orderby were empty. Why?

Answer 1

Did you turn the filter on?

Me.Filter = "Country = 'USA'"
Me.FilterOn = True

Check out msdn for more information regarding filters: https://msdn.microsoft.com/en-us/library/office/ff194672.aspx