Need some help with Form Filters

[BWD]

Hello group,

I am struggling with how to create a constant filter for one of my
forms. This is the structure of my forms and the desired filter:

Main Form: Subform1: Subform2

I would like to filter Subform2's data based on a value in Subform1.
Specifically Subform2 has an Order# and Order date field. I would
like subform2 to only display records that fall between 2 date values
listed on suborm1 (let's call them date1 and date2)

I just cant seem to figure this out so that:

A) The filter works
B) The filter, once defined, always stays on any time I open the form.

Thanks!!!

 

[Pieter Wijnen]

won't happen as such
but if a requery of subform2 is triggered by change of subform1?

Pieter